Custardptt
Technical User
Hi All,
I'm attempting to export data from several related tables as XML. The Structure is rather particular and looks something like this
BaseTable
Table2
Table3
Table4
When I do the Export, only the first relationship is preserved and the XML looks like:
BaseTable
Table2
Table3
Table4
If I manually export the table as it works fine.
My Export script look like this:
Dim AdData As AdditionalData
Set AdData = Application.CreateAdditionalData
AdData.Add "Table2"
AdData.Add "Table3"
AdData.Add "Table4"
Application.ExportXML acExportTable, "BaseTable", "C:\export.xml", , , , acUTF16, , , AdData
I had assumed that there's a way of telling the AddittionalData object how the other tables are related but I cant see how this is done and google has failed me this time.
Does Anyone here know
Thanks in advance
Pete
I'm attempting to export data from several related tables as XML. The Structure is rather particular and looks something like this
BaseTable
Table2
Table3
Table4
When I do the Export, only the first relationship is preserved and the XML looks like:
BaseTable
Table2
Table3
Table4
If I manually export the table as it works fine.
My Export script look like this:
Dim AdData As AdditionalData
Set AdData = Application.CreateAdditionalData
AdData.Add "Table2"
AdData.Add "Table3"
AdData.Add "Table4"
Application.ExportXML acExportTable, "BaseTable", "C:\export.xml", , , , acUTF16, , , AdData
I had assumed that there's a way of telling the AddittionalData object how the other tables are related but I cant see how this is done and google has failed me this time.
Does Anyone here know
Thanks in advance
Pete