getXML on dataset with Multiple tables and exporting to Excel

G

Guest

I have a dataset with multiple tables I need exported to Excel. I can get it
into Excel into one worksheet however I want there to be one worksheet for
each datatable in the dataset. If I dump my xml string from the getXML method
into Excel it puts all the data from the tables into the same worksheet.

I am using the XMLImportXML method that's available with Office 2003.

Do I have to loop through each datatable and use getXML and XMLImportXML
separately? Is there something that could be generated from perhaps the
getXMLSchema method that tells Excel to put each table in a separte worksheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XMLImportXML method using getXML/writeXML method on dataset with m 0
DATASET TO XML ( ---NULL COLUMNS--- ) PLEASE HELP ME!!! 1
GetXML, DataSet and dataview 4
dataset getxml xml formatting 3
DataSet XML load and save 1
problem with DataSet.GetXml() method 1
creating an xsd through xsd designer - xml format 1
DataSet - GetChanges() and Merge() Questions 1

Top