newbie XML/DOM question

[quercus]

Hi,
I want to export queries from a MSAccess database to XML on the client using the IE5 XML parser.

Can anyone tell me whether MS Access 2000 can use DOM to create XML files on the client? (i dont have Access2002)
Or should i be using VB6 to to this?

Any suggestions much appreciated.

 

[Vince]

Hi,

I dont really know what you are trying to do. I will asume that you are trying to export the results of access queries into xml files. If so you will need to use VB6

this is a quick walkthrough of how you could do it

in the VB exe regerence the ADO libraries

create an instance of the connection object

dim cn as new ADODB.connection

connect to the database

cn.connectionstring = "myDSN" (you can create a dsn or use a connection string

execute the query you want to save

rs = cn.execute("someQuery&quot

then save the recordset
rs.save("mypath.xml",ADPersistXML)

I hope that this is of some use