Multiple table XML export

[SteveF]

I have an application which imports and exports data sent from/to a major client. The client sends their data in XML format, and I return data the same way using Application.ExportXML

Until now, I've just exported the contents of a single table to the XML file, and it's worked well. However, the client now wants to receive one XML file that contains the contents of two tables in the application.

According to Access Help, this is theoretically possible. However, my attempts to follow the directions to do this have been less than fruitful. The uncertainty I have is in exactly how to populate the "AdditionalData" parameter which is supposed to handle adding the second table to the XML file.

Any assistance would be appreciated.
TIA,


Steve

[June7]

Why is it not working - error message, nothing happens, wrong results? Post your code for analysis.

Third time's a charm, got my test to work. Exported 4 tables.

[SteveF]

Why is it not working - error message, nothing happens, wrong results? Post your code for analysis.

Third time's a charm, got my test to work. Exported 4 tables.

Wrong results: Only the data supplied by the query specified in the DataSource parameter is included in the XML file. What's unclear to me is the specific way to include additional tables -- the example in MS Access Online Help is not consistent or specific enough for me to make sense of it.

Would you please post your test code?

Thanks,
Steve

[June7]

It is the same as found at http://msdn.microsoft.com/en-us/library/ff193212.aspx

When I succeeded with 3 tables per the example I included another .Add line to get 4th table.

Post your code for analysis.

[orange]

Hey June7 thanks for the link. I have acc2003 on XP.
I could never get Access to export multiple files (although it was more of a test once or twice than serious work), but this example worked. I also added a 4th table as you did in your test. Worked well.

I'm not sure what I'd really use it for. I'm not sure how to read the xml -- any suggestions.. links.. samples?? I did do something a few years ago, when working, to get some xml from website, then use some vba code and (I think xmlspy 2005 or so) to convert the xml to some .txt files for import into access. Hokey, but it solved an issue at the time.

[June7]

The only thing I know xml files are good for is loading data to web pages with html code. I am sure you could google 'what is xml file' and get clues on how to read them, try Wiki.

[SteveF]

It is the same as found at http://msdn.microsoft.com/en-us/library/ff193212.aspx

When I succeeded with 3 tables per the example I included another .Add line to get 4th table.

Post your code for analysis.

Well, it's working now; here's the code that works, thanks to another source of assistance:

Private Sub XML_OutSendBtn_Click()
'export query to selected XML file
    Dim ExportFileStr As String
    Dim objSchedule As AdditionalData
    
    ExportFileStr = XML_PathEdit
    Set objSchedule = Application.CreateAdditionalData
    
    If Right(ExportFileStr, 4) <> ".xml" Then
        ExportFileStr = ExportFileStr & ".xml"
    End If
    
    Set objSchedule = objSchedule.Add("NCOA_MatchTbl")
    objSchedule.Add ("attend_schedule")
    
    Application.ExportXML acExportQuery, "AddressUpdateReturn", ExportFileStr, , , , , acEmbedSchema, , objSchedule

End Sub

What was not to me clear from Online Help (and MSDN, which has the same information) was that EVERY TABLE containing data that is to be included must be included in the AdditionalDataObject.Add sequence.

<EDIT> FWIW, XML files are being used in this scenario to transfer data files to & from our site and our client's site(s). XML was selected as a "common" format understood and importable/exportable by the two different systems in use in our respective locations.

Steve