In newer versions of Access:

File > Export > File Type > *.xml

I always end up cleaning the exported file up with a text editor and regular
expressions (could do it in XSLT, but this is easier) as the straight export
never is quite what I would have done. I believe there may be a way to link
the export to a schema, so the output format will be more determined, but I
haven't done it. Check Access's Help file.

-- Brook


> From: puja thakral <puja_thakral@xxxxxxxxx>
> Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Date: Mon, 29 Sep 2003 08:23:26 -0700 (PDT)
> To: List <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
> Subject:  how to import access database to xml?
> 
> Hi All, 
> Can anyone give me a clue on how to create XML from
> Access dirctly.I was trying it with XML Spy.But it
> gives me an error that 'Records cannot be read.No read
> permission on the folder.I tried to set the properties
> in the?access database?but it doesn't help.
> Can anyone help pls?
> Thanks, 
> Puja 
> 
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> 
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 
> 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list