Export Data to Excel

[meny21]

Hi!!!

Do you know guys, how can I export data from SQL Server or Access using Visual Basic?

I mean, I put a button for the user and when he clicks, all the data instead a report go to Excel WorkSheet.

Thanks for any help!!!!

MR

 

[chadt]

you could always use the recordset and excel object library.

First read the data in....then create the spreadsheet from the recordset.

I would do a search for Visual Basic Excel either here or on google.

 

[MangroBongacello]

See this link:

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

 

[meny21]

Thank you!!!

I will check it!