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 |
|
Ghanta
Yak Posting Veteran
96 Posts |
 Posted - 2011-01-13 : 12:21:22
|
| I need to export bunch of SQL 2008 tables into excel and since tables have millions of records... I need to break the export into multiple excel files.... does someone have a Proc to do this type of export? Or a SSIS package? Thanks in advance for help. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-01-13 : 13:02:02
|
| i dont know about any procedure but if you know about BCP utility you can use it for export of data into excel files |
 |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-01-13 : 13:24:35
|
quote:
Originally posted by MIK_2008
i dont know about any procedure but if you know about BCP utility you can use it for export of data into excel files
Yes I have used bcp utility before... |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-01-14 : 00:43:36
|
| you can also use openrowset and export wizard. |
|
|
|
|
|
|
Stored Proc to Export into Multiple Excel File