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(_at_)yahoo(_dot_)com>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Date: Mon, 29 Sep 2003 08:23:26 -0700 (PDT)
To: List <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: [xsl] 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