Hi,
I am trying to import an text file but get the error message 'Text File Contains more data than will fit on a worksheet'. This is because the file has too many rows for one worksheet.
So I import what is posible on the worksheet and then run the wizard again on a second worsksheet and click start at row 65536 as that is the last row on the first worksheet. I then click next and get a error message invalid interger?
What I am doing wrong?
I am trying to import an text file but get the error message 'Text File Contains more data than will fit on a worksheet'. This is because the file has too many rows for one worksheet.
So I import what is posible on the worksheet and then run the wizard again on a second worsksheet and click start at row 65536 as that is the last row on the first worksheet. I then click next and get a error message invalid interger?
What I am doing wrong?