import problem on huge xls file

F

f_huba

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:
 
N

N Harkawat

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have lost 6 months work, how can i get my file back 1
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Merge Excel file into Word Document 3
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Adding a big matrix in Word 2013 5
Excel 2013 cannot open simple text file with .acc extension 1

Top