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 |
|
Informer30
Starting Member
26 Posts |
 Posted - 2014-03-24 : 08:22:35
|
| Hi All,I am exporting data from sql 2008 r2 db to csv, the maximum the csv is showing is 1,048,576 whilst the actual count in sql is over 2 million.Is there an limit within SSMS db/tasks/export?thanks in advance... |
|
|
sqlsaga
Yak Posting Veteran
93 Posts |
Posted - 2014-03-27 : 11:52:45
|
| do you have to do it only to a CSV?? Can you not do it an Excel file??If the answer for above question is YES and you can use MS Excel 2007 or above, you can do it in the straight forward fashion but the only problem is due to the amount of data(2Million) you will encounter issues while opening the file..You can create one sheet for 65000 records and have multiple sheets in the same excel. I think that way is a better solution for this...Visit www.sqlsaga.com for more t-sql snippets and BI related how to's. |
 |
|
|
|
|
|
Exporting data to CSV