Extending worksheet row number

S

SirJohn

Hi all,

I have a big problem.
I have to import a 120.000 lines text file into a excell worksheet...
But! an worksheet has only 65535 lines... :confused:

Is it any way to have more lines in an excel worksheet?

All the best to you!
 
B

Bernard Liengme

Why confused. Everything has its limits and Excel has a limit of 65535 rows.
Use either Access or QuattroPro
Or spread the data over a number of sheets.

Sorry, Sir John, I cannot give you more consolation.
Your obedient serf
Bernard
 
Top