Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Importing and Exporting XML Data

0 views
Skip to first unread message

Wesley Holt

unread,
Jul 13, 2003, 10:52:50 AM7/13/03
to
Hi,

I've searched Knowledgebase and help but have not found a
solution, so i'm asking for help. Is there a was using
code to export a table to a XML file and then using code
import XML files to a empty table.

I'm trying to save a table to an XML file, delete the
records in the table and have the ability to import the
XML file back into the table at a later date.

Any help is appreciated!
.


Mike

unread,
Jul 14, 2003, 10:10:03 AM7/14/03
to
You can do this using Data Junction (if you have it). If
not go to www.datajunction.com

>..
>
>
>.
>

Joe Fallon

unread,
Jul 14, 2003, 9:23:57 PM7/14/03
to
You don't mention the version of Access.
(It kinda makes a difference.)

A97 - you can export ADO recordsets to XML.
Must write your own import routine.

A2000 may have save as and import XML (can't recall)

A2002 definitely has it.

A2003 improves upon it.
--
Joe Fallon
Access MVP

"Wesley Holt" <doct...@hotmail.com> wrote in message
news:050a01c3494e$6e5ab160$a301...@phx.gbl...

0 new messages