Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert .csv to .xls for very large file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert .csv to .xls for very large file
See KB article for info and code.
http://support.microsoft.com/default...;en-us;Q120596 Alternative. Change the extension from csv to txt then break it into manageable *.txt files and open those into separate worksheets. Gord Dibben MS Excel MVP On 17 Apr 2007 10:53:34 -0700, 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert .csv to .xls for very large file
Thanks Gord. That was exactly what I was looking for.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Can you save 1 sheet from a large file into another file? | Excel Worksheet Functions | |||
File Too large | Excel Discussion (Misc queries) | |||
How do I convert the result of LARGE to the cell (or column) refe. | Excel Worksheet Functions | |||
Large File 56M | Excel Programming |