Export to CSV

[Tal]

Hi
I have a 3 million records dataset that i want to export to excel csv. I was told csv can have way more than a 1M records but after exporting it i only see 1,048k
You guys know a way of doing this?
I need the 3M records in one tab so business partners would be able to do pivot tables out of that file. Any suggestions pls?

[Reeza · Accepted solution]

CSV is a comma separated values file, and Excel can read a file in that format.

CSV can handle unlimited records but Excel can only read 1 million records. You need a different workaround. Consider exporting to an Access DB and then connecting your Excel workbook to the Access DB. If you need to email the file that's not going to be workable. 

Otherwise Excel will not be a good solution, especially if you can't split your file into multiple sheets. 

[Reeza]

If you can get the PowerPivot add in, that does seem to provide a workaround. You'll need to look into that further yourself. 

[PGStats]

You or your business partners could do the pivot tables directly in MS-Access. 

[LinusH]

Or keep the data in SAS and use the SAS OLEDB provider/SAS Addin 4 MS Office.

[Norman21]

As already stated, the contraint is built into Excel, not the CSV file.

If you want to view the large CSV file, try something other than Excel. Here is a link to a freeware program that might be useful:

http://csved.sjfrancke.nl/

[Tal]

Thx Reeza thx guys for your inputs but we dont have MS Access at work. Can that be possible? Have everything under MS Office but Access

[Reeza]

That's pretty standard, Access is available under a different license and has an additional cost.