Export to Excel

[joel009]

Is there a way in VB to export a recordset directly to Excel with out going through the rows and columns? Just a straight dump to an Excel template. I know you can do it in Access VB but haven't been able to accomplish it in VB.

Thanks,

Joel

 

[johnwm]

Yes there is. Try this:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q278973

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[joel009]

johnwm,
It looks like the only way shown there is by going through Access. Do you know of a way to go directly from a VB6.0 recordeset to Excel? We are thinking of using a template from Excel but don't want to include the use of Access.

Thanks

Joel

 

[johnwm]

I should have been clearer. That page gives an overview of Excel and ADO - at the bottom of the page are the further references.

They eventually point to :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;247412

where you will find details for transferring data from VB by numerous methods to suit different requirements and different data quantities
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[joel009]

johnwm,
I had already found the links and the info I needed, I think, before you replied. Trying it out now. For others with the same question look at reference 246335, CopyFromRecordset.

Thanks John,

Joel

 

[ReturnOfThePyro]

how can i do the opposite? Import info from an excel sheet?