Importing and Exporting XML Data

[Wesley Holt]

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]

You can do this using Data Junction (if you have it). If
not go to www.datajunction.com

 

[Joe Fallon]

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.