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
|