Data Adapter for XML

  • Thread starter Thread starter Dan Boehm
  • Start date Start date
D

Dan Boehm

Does anyone know of a data adapter that supports XML? I
have a small database that is just an xml file and would
like to be able to run simple sql statements against it.
Does anyone know how this can be done?
 
You could load the xml file into a dataset using readxml method and then use
DataViews to get the data you need from the dataset.

Good Luck
 
Hi Dan,

In addition to Mike, you can use the datatable.select method to do some SQL
lookalike statements on your XML Dataset.

myarray = ds.tables(x).select(.................................)
Where myarray is an array of datarows.

I hope this helps?

Cor
 
Back
Top