exporting Access 2002 queries as XML?

[Jim]

Looking at the automation objects exposed by the
Microsoft Access 10.0 Object Library, I see that the
ExportXML method is accessible at the Application object
level. From this, I assume that I can only export the
entire database as a whole. What I would like to do is
instantiate a QueryDef object and export the contents of
it's associated Recordset as XML which would be a
qualified subset of the entire database. Is this not
possible? Thanks.

Jim

 

[Distance]

Hi Jim

Havent tried the export from Access directly, but I pull
data from Access into XML using XML Spy.
http://www.xmlspy.com/--try the free trial download.

There you can Import the entire Database, or a selection
thereof. Also you can export raw XML to Access Tables,
with automatic primary and foreign keys.

Database schemas, Stylesheets with select statements the
works, all there...hope you enjoy

PS: you can generate XML from Excel with VB but its a drag

 

[Jim]

XML Spy is a great tool, but is there a way to
programmatically extract portions of a database into
XML? Thanks.

Jim