Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML and ADO 1

Status
Not open for further replies.

lovehuman

Technical User
Apr 17, 2001
30
0
0
SG
Hi,

I have a file which contains data in XML format. I want to create ADO recordset out of it and then display the data in the datagrid. How is this possible? Any help will be appreciated.

Thanx
 
Use the Open method with the name of your file:
[tt]
rs.Open "titles.sav",,,,adCmdFile
[/tt]

You should be aware that if you use this to create your file:
[tt]
rs.save s, adPersistXML
[/tt]
that ADO will not add fields to the XML that have <null> values. (huge bug!)

Chip H.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top