How can I dump a dataset to word

[donnacha]

Hi folks,
does anybody know what the easiest way to dump a dataset to word is that doesent take all day to transfer the data.

Is it somehow possible to do using the xml repsentation of the dataset, and if so how can one generate ans xslt from the dataset.


Any Ideas

 

[Mike_R]

Donnacha,

I am pretty weak at Word and I know nothing about XML/Databasing... I wonder if your Q might be better posted in the Database / XML / Reporting Forum?

Just a thought, or are you looking for a Word-specific feature here?

-- Mike

 

[Optikal]

you can use the WriteXml() method of the dataset to output an XML representation. If you then want to transform that xml into some other format you can always create your own XSLT to do that.

 

[donnacha]

I think you are missing the point. What I ultimately want to do is dump the dataset information into a table in an MS Word document. I can do this by looping through the dataset and writing to individual cells in the table in word, the only problem is that this is so slow that it hurts to sit and watch it.

So what I was thinking wast I could take the xml representation of the dataset and dump this, now I have seen exampls of this done but they all rewuire one to manually create an xslt, my problem is that my dataset is dynamically generated and can be different everytime, so I need a way to do this on the fly as they say....

Any more ideas ....

 

[donnacha]

Any suggestions of even other ways of doing it are welcome.