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

K

KurtHan71

How Can I import external data what is more than 65536 lines? I would like to
import *.csv or *.txt files.
 
T

Tim879

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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
text file contains more data than will fit for a single worksheet 1
Import more than one .csv file into the same Excel file. 1
Importing text more than 65536 having delimiter functions 2
more than 65536 rows 13
Data which is over 65536 lines long 1
What is the maximum number of rows in an Excel spreadsheet ? 5

Top