How Can I import external data what is more than 65536 lines?

  • Thread starter Thread starter KurtHan71
  • Start date Start date
K

KurtHan71

How Can I import external data what is more than 65536 lines? I would like to
import *.csv or *.txt files.
 
As far as I know, you either need to use Excel 2007 or split the text
file into multiple files and import the data on separate tabs.


For a data file that large a better solution would be to use Access to
analyze your data.
 

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

Split a text file with more than 65536 lines over many worksheets 4
more than 65536 rows 13
text file contains more data than will fit for a single worksheet 1
Last row on spreadsheet is row # 65536. How can I add more rows? 3
What is the maximum number of rows in an Excel spreadsheet ? 5
Data which is over 65536 lines long 1
Why Excel 2007 still have the 65536 raw limit? 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top