Autodesk Database to XML with VBA

[jluost1]

I am using autodesk Map 3D 2005. I need to create a macro inside the autodesk Map. This vba macro will make connection to database as appears in "data source", extract the data in the database, and save the data into a xml file sequencially (read data and always append to the end of the file).

Which object can I use for XML writing? Or, which reference do I need to add?

I used XMLstream object for other applications. The XMLStream object will read the data and I can save the stream to a file. I wish XMLStream is available for Autodesk also, but I don't find it.

Thank you so much in advance.

 

[TCARPENTER]

Hi jloust1,

If you can't find the dll/ocx with the browse button, try using ADO. ADO can read and write XML, I've only persisted recordsets to XML files so I'm quite sure how you would go about it, but microsoft has detailed information on ADO and XML on their website.

HTH
Todd