how to import data from text file which has more 70k rows ?
 

I have to import data which has more than 70,000 rows.

How can I import ? I beleive that you can import on 64k or 65k rows.

Any suggestions ?

Thanks

how to import data from text file which has more 70k rows ?
 

-----Original Message-----

I have to import data which has more than 70,000 rows.

How can I import ? I beleive that you can import on 64k
or 65k rows.

Any suggestions ?

Thanks


.


You are correct on the row limits - precise limitations
are available by looking up the specs in the help file.

Consequently you won't be able to handle your imported
data on one sheet if you put one record per row. Only
suggestion would be to split the data up between multiple
worksheets if that is practical.

If not, maybe you need to use a database app instead.