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

  • Thread starter Thread starter meh
  • Start date Start date
M

meh

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
 
-----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


.
Click to expand...

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.
 
Back
Top