DaniWeb IT Discussion Community - Exporting to Excel from SQL Server DB

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- MS SQL (http://www.daniweb.com/forums/forum127.html)

- - Exporting to Excel from SQL Server DB (http://www.daniweb.com/forums/thread77617.html)

Aswathy

May 7th, 2007 5:21 am

Exporting to Excel from SQL Server DB

Hi,

I need to export data from two seperate tables in database to the same sheet in excel. ie, the data from the tables should appear one below the other in the same sheet of excel.

Could any one tell me how this can be made possible.Also could any one tell me whether it is possible to format the cells of the resulting excel.

Thanks in advance,
Aswathy

MidiMagic

May 8th, 2007 1:38 am

Re: Exporting to Excel from SQL Server DB

Can't you just create a report file in the form you want it, and then import that.

All times are GMT -4. The time now is 11:17 pm.