469,592 Members | 1,927 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

XMLImportXML method using getXML/writeXML method on dataset with m

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
Nov 22 '05 #1
0 2317

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by RS | last post: by
2 posts views Thread by Rajesh AVRS | last post: by
1 post views Thread by Kashyap | last post: by
2 posts views Thread by Ganesh Muthuvelu | last post: by
1 post views Thread by lucky | last post: by
reply views Thread by =?Utf-8?B?bXJjc2hhcnBtYW4=?= | last post: by
4 posts views Thread by =?Utf-8?B?anAybXNmdA==?= | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.