Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samar.knp
Starting Member
2 Posts |
 Posted - 2011-05-25 : 09:49:28
|
| hi, I want to export data in multiple sheets on a single excel file.I was able to export data in a single sheets but I am getting issue in export data in the other sheetsplease give me hints/code for thisthanks |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-05-25 : 10:22:16
|
| How are you doing the export? What kind of error messages are you getting?If you use DTS using the Import/Export Wizard, for each table/view that you select to be exported, it lets you specify the sheet name on which to copy the data to. By default it should assign the table name as the sheet name. You have to specify the sheet name in single quotes as in `Customers`, `Orders` etc. |
 |
|
|
|
|
|
Export data from table to multiple excel sheets on