How to extract entire database to XML and from XML back to MDB file

S

Siegfried Heintze

Does anyone know of an automated way to extract the entirety of a MDB file
to a XML flag file? I see there is a way to extract single tables from the
menu, but I would like to store the entire MDB file in a flat file(s), store
it in a versioning system (eg, CVS) that computes and stores deltas,
retrieve it from the versioning system and rebuild the MDB file.

Thanks,
Siegfried
 
A

Allen Browne

To get the list of the tables, loop through the TableDefs.

Alternative: OpenRecordset() on this query:
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] In (1,4,6))
AND ([Name] Not Like "~*")
AND ([Name] Not Like "MSys*"))
ORDER BY MsysObjects.Name;
 

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

Top