file not loaded completely

J

John Kantuik

I have a ascii file .txt. It contains around 180.000 row data
When I try to open it in excel, there was an error "file not loaded completely"
Can anyone help to handle this
Thanks
 
F

Frank Kabel

Hi
Excel has a limit of 65536 rows per worksheet. No way around this. One
workaround:
- open the file with a text editor
- split this file into 3 parts of 60000 rows each
- import these three files separately to three different worksheets
 
Top