Thread: Writing Data to excel
View Single Post
  #1 (permalink)  
Old May 14th, 2004, 06:59 AM
acdsky acdsky is offline
Friend of Wrox
Points: 456, Level: 7
Points: 456, Level: 7 Points: 456, Level: 7 Points: 456, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2003
Location: Johannesburg, , South Africa.
Posts: 141
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to acdsky
Default Writing Data to excel
Hi

Has anybody got some good examples for writing data to excel from a VB6 app?
I need to create a new workbook, name and create about 10+ sheets. Then write data to the sheets and save it and close it all in the background.
Would it be better to use ODBC(excel driver) to write the data and handle the sheets as tables? In previous apps I used DTS in SQLserver but this time it will not work for me.

Please point me in the right direction.
Reply With Quote