Exporting multiple tables as XML

[FuzMic]

Hi friends

I can use the following codes to export from Table1 to the exported.xml file.

Application.ExportXML _
ObjectType:=acExportTable, _
DataSource:="Table1", _
DataTarget:="Exported.xml"


If I also want to export multiple tables, can i use the following from Access 02/03.

Dim objOtherTbls As AdditionalData
Set objOtherTbls = Application.CreateAdditionalData

objOtherTbls.Add "Table1"
objOtherTbls.Add "Table2"
objOtherTbls.Add "Table3"

Application.ExportXML ObjectType:=acExportTable, _
DataSource:="Table1", _
DataTarget:="Exported.xml", _
AdditionalData:=objOtherTbls

I think Access 03 Application will have problem recognising CreateAdditionalData. Is this correct, what is the work around if so.

Your help much appreciated.

 

[FuzMic]

For sharing i just found that with Access 03, Application recognised CreateAdditionalData, thus multiples tables must be exported in one go. Access 02 don't know about this. That's it.