Loads several XML files into a Dataset...

[scobiej]

...using VB.NET and query against the dataset using SQL?

I have exported each table in my MS-Access database to individual XML files.

Using VB.NET i want to treat these files as if they were tables in a database, i.e. perform SQL joins against them to represent the data any way i want. All fetches will be for display (read only) purposes.

Can anyone recommend the best approach for this? So far I have created a generic data access class and have got familiar with data sets when working against an access database.

However, I need to implement my solution using XML text files because the company will not allow MDB's to be accessed from the server. I need to go down this XML road.

Many thanks
John

[nemaroller]

Seems like it would be fairly using the DataSet.WriteXml and ReadXML methods.