Importing and Exporting XML Data

  • Thread starter Thread starter Wesley Holt
  • Start date Start date
W

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!
..
 
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.
 
Back
Top