Thread
:
convert .csv to .xls for very large file
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gord Dibben
external usenet poster
Posts: 22,906
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben