Microsoft Access 2007: Export to multiple xml files

717 Views Asked by At

I have a table in my access database and I want to export each record to a single xml file. How can I achieve this?The only option I found was exporting the whole table to a single xml file.

1

There are 1 best solutions below

2
On

Any saved object can be exported to XML. This would include a saved QueryDef filtered to the records you want to export. The filtering can be done by tying the QueryDef's WHERE clause to controls on a form whose purpose is to allow the user to specify the desired record(s), or you can change the WHERE clause of the saved QueryDef in DAO code. I prefer the former to editing saved QueryDefs.