import problem on huge xls file

  • Thread starter Thread starter f_huba
  • Start date Start date
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:
 
I usuually import it in MS-Word or any text based editor
Then cut and paste about 65000 lines in separate sheets
 
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
 
You must log in or register to reply here.

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel file extension is camouflaged as xls 1
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Sharing Data Between 2 .XLS Files 2
Automated Solution to Repair PST Files 2
Open .xlsx files in Excel 2002 2
Excel Excel cannot open .xls file 0
opening new csv file in existing xls file's worksheet 4

Back
Top