Hi Shank,

You should download Altova's MapForce product and map the Access Db to the 
3rd party's XSD file. This is the best solution for you!

You can download a fully functional trial version here, 
http://www.altova.com/download/mapforce/data_mapping_professional.html

Once you've downloaded this product, you simply create a new mapping file, 
add your Access Db as a source component in your mapping file, add the 3rd 
party schema file as a target and map the two together. It's that simple!

If you need help, please contact the support team from the following page, 
http://www.altova.com/support_center.html



-- 
Best regards,

... Jerry Sheehan

http://www.altova.com

"shank" wrote:

> I know what an XML file is when compared to HTML. But this is the first time 
> I've ever had to work with them. I have data in Access. I need to export 
> that data using a 3rd party's XSD schema file into a data feed. I have the 
> trial version of XMLSpy and basically lost.
> 
> I exported XML out of Access and sent to the company for validation. It 
> didn't match their XSD.
> 
> How do I put all this together?
> 
> The export from Access includes <dataroot ...>, which the company says does 
> not belong.
> 
> The table name exported as the element container for each record. The 
> company requires <prodcont> as the element. Do I need to change table names, 
> search and replace or change something else?
> 
> Do I export from Access, then manually change elements? In my mind their 
> should be some way to map the data to the correct elements.
> 
> thanks! 
> 
> 
>