Connecting Tech Pros Worldwide Help | Site Map

XMLImportXML method using getXML/writeXML method on dataset with m

  #1  
Old November 22nd, 2005, 11:01 PM
softengine
Guest
 
Posts: n/a
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?


--
bill

--
bill
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
XMLImportXML method using getXML/writeXML method on dataset with m softengine answers 0 September 14th, 2005 10:55 PM