Importing and Exporting XML Data

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!
..
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing XML Data in Access 2003 1
XML into Access 2003 3
changing the name of a table created by importing an XML document 1
Exporting data to xml file 3
Export to XML - error 31532 0
Importing Multiple XML files into Access 2003 1
Import xml to Access 2007 question 0
How do I import xml file into MS Access table 1

Top