Maybe you can open it in Notepad (or your favorite text editor) and save it into
smaller bite size pieces.

Then import each smaller piece into its own worksheet/workbook.

kookaburra wrote:

How do I transfer a zipped csv file to Excel where the zipped file contents
are too large to fit into the 65k+ rows in Excel?
I get the message "File not loaded completely" when I open the file. What do
I have to do to load the complete contents fo the file?
thanks
Glenda

--

Dave Peterson

Thanks, Dave
It wouldn't open in wordpad (file too big) but I opened it in the Winzip
suggested text editor. Data of course appeared as comma delimited and, whilst
I copied it in sections and pasted to Excel, it is still in csv format. I
tried saving data as a CSV file and thought that if I reopened it would allow
a data conversion process. It didn't. Any ideas?
thanks
Glenda

"Dave Peterson" wrote:

Maybe you can open it in Notepad (or your favorite text editor) and save it into
smaller bite size pieces.

Then import each smaller piece into its own worksheet/workbook.

kookaburra wrote:

How do I transfer a zipped csv file to Excel where the zipped file contents
are too large to fit into the 65k+ rows in Excel?
I get the message "File not loaded completely" when I open the file. What do
I have to do to load the complete contents fo the file?
thanks
Glenda

--

Dave Peterson

If you saved the smaller files as .csv files, then you excel should have
imported it ok.

But if you have a different list separator in your control panel|regional
settings applet than what shows up in those .csv files, you could have trouble.

For instance, I use comma to separate my fields. I have that windows setting to
comma. It works ok.

If you use a semicolon as your separator and the data contains commas, you could
have trouble.

If you have your data in excel already (each worksheet has just one used column,
right???).

You can use the Data|Text to columns for each worksheet and specify the field
separator.

That dialog will look just like the import text wizard.



kookaburra wrote:

Thanks, Dave
It wouldn't open in wordpad (file too big) but I opened it in the Winzip
suggested text editor. Data of course appeared as comma delimited and, whilst
I copied it in sections and pasted to Excel, it is still in csv format. I
tried saving data as a CSV file and thought that if I reopened it would allow
a data conversion process. It didn't. Any ideas?
thanks
Glenda

"Dave Peterson" wrote:

Maybe you can open it in Notepad (or your favorite text editor) and save it into
smaller bite size pieces.

Then import each smaller piece into its own worksheet/workbook.

kookaburra wrote:

How do I transfer a zipped csv file to Excel where the zipped file contents
are too large to fit into the 65k+ rows in Excel?
I get the message "File not loaded completely" when I open the file. What do
I have to do to load the complete contents fo the file?
thanks
Glenda

--

Dave Peterson


--

Dave Peterson

I had saved the files as .csv and, as you suggested, used Data/Text to
columns and specified the field separator - comma delimited. It worked!
Thank you so much.
Glenda

"Dave Peterson" wrote:

If you saved the smaller files as .csv files, then you excel should have
imported it ok.

But if you have a different list separator in your control panel|regional
settings applet than what shows up in those .csv files, you could have trouble.

For instance, I use comma to separate my fields. I have that windows setting to
comma. It works ok.

If you use a semicolon as your separator and the data contains commas, you could
have trouble.

If you have your data in excel already (each worksheet has just one used column,
right???).

You can use the Data|Text to columns for each worksheet and specify the field
separator.

That dialog will look just like the import text wizard.



kookaburra wrote:

Thanks, Dave
It wouldn't open in wordpad (file too big) but I opened it in the Winzip
suggested text editor. Data of course appeared as comma delimited and, whilst
I copied it in sections and pasted to Excel, it is still in csv format. I
tried saving data as a CSV file and thought that if I reopened it would allow
a data conversion process. It didn't. Any ideas?
thanks
Glenda

"Dave Peterson" wrote:

Maybe you can open it in Notepad (or your favorite text editor) and save it into
smaller bite size pieces.

Then import each smaller piece into its own worksheet/workbook.

kookaburra wrote:

How do I transfer a zipped csv file to Excel where the zipped file contents
are too large to fit into the 65k+ rows in Excel?
I get the message "File not loaded completely" when I open the file. What do
I have to do to load the complete contents fo the file?
thanks
Glenda

--

Dave Peterson


--

Dave Peterson