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 |
Angeline87
Starting Member
7 Posts |
Posted - 2013-02-16 : 19:42:46
|
Hi to everybodyHow can I export all tables of a database to one excel file (each table should be one spreadsheet in the excel file) by using SQL Code? Important remarks:- The export should be generated via (T-)SQL Code not else how. - I am using SQL Server 2008 R2- I am using MS Office 2007Any ideas? Thanks a lot for your support in advanceAngeline |
|
Angeline87
Starting Member
7 Posts |
Posted - 2013-02-16 : 20:04:44
|
Additional requirements- The Excel File should be created by SQL Code (it does not exist in advance)- The tablenames are dynamic; I don't know the names in advance. Therefore the skript should dynamically read table names (using something like a for-loop)Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|