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

How to remove external organization from Office. 0
Split a text file with more than 65536 lines over many worksheets 5
Import more than one .csv file into the same Excel file. 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
text file contains more data than will fit for a single worksheet 1
data with more than 65536 lines 3
How to import external data into excel? 2
Convert First Line indent into Tabs 0

Top