import problem on huge xls file
 

I have a huge xls file. (183MB)

I created this file from mysql database and I forget to split in
multiple worksheet (and deleted de mysql file) :( ...
in this xls file I have 129700 records...
in excel i can open the file but only the first 65536 records is
visible...

how can I recover the file? :confused:


--
f_huba@toplita.
------------------------------------------------------------------------
f_huba@toplita.'s Profile: http://www.excelforum.com/member.php...o&userid=16089
View this thread: http://www.excelforum.com/showthread...hreadid=275407

I usuually import it in MS-Word or any text based editor
Then cut and paste about 65000 lines in separate sheets

"f_huba@toplita." wrote in
message ...

I have a huge xls file. (183MB)

I created this file from mysql database and I forget to split in
multiple worksheet (and deleted de mysql file) :( ...
in this xls file I have 129700 records...
in excel i can open the file but only the first 65536 records is
visible...

how can I recover the file? :confused:


--
f_huba@toplita.
------------------------------------------------------------------------
f_huba@toplita.'s Profile:
http://www.excelforum.com/member.php...o&userid=16089
View this thread: http://www.excelforum.com/showthread...hreadid=275407

Your Excel file has 65,536 rows of data on the first worksheet.

Everything else is gone. You cannot recover what was not placed in there.

Re-create your database file and do it again but this time remember to split
into worksheet-sized chunks.

Gord Dibben Excel MVP

On Thu, 4 Nov 2004 14:00:35 -0600, f_huba@toplita.
wrote:


I have a huge xls file. (183MB)

I created this file from mysql database and I forget to split in
multiple worksheet (and deleted de mysql file) :( ...
in this xls file I have 129700 records...
in excel i can open the file but only the first 65536 records is
visible...

how can I recover the file? :confused: