convert .csv to .xls for very large file
You may want to try our Excel 2007.
The total number of available rows in Excel:
Old Limit: 64k (2^16)
New Limit: 1M (2^20)
" wrote:
I'm receiving a very large .csv file. It is too large to open it
directly in Excel. I need to manually split it in different file and
then open it in different Excel tab. I'm using Office 2003.
I'm looking to build a macro that open the .csv file as a text file,
and split it in different tab in Excel so I can view all the
information of the .csv file in the same Excel workbook; just in
multiple tab.
Is there a way to do that?
Thanks
|