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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import tab text data(more than 65K rows) into excel by VBA 2
How to rank multiple columns by different contribution levels to rankin Excel? 4
Import Text File Directly to an Array 6
Import Text file Data into Excel Sheet 3
working with large text files 4
Sort on 3 columns when number of rows vary daily 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import multiple workbooks to current workbook in specified row number 0

Back
Top