MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Import text file of over 85000 records

Posted by JAF on June 26, 2001 6:45 AM


I have a text file that contains (this month) over 85,000 records. the actual number of records the file could contain each month is likely to fall between 70,000 and 250,000 records.

Obviously Excel has the 65536 record limit and i know that when importing text files there is a limit as to how "far down" you can set the starting row (32,000 I think).

Is there any way to get Excel to import this large text file either onto separate sheets or to "wrap" the import so that when the maximum number of rows is reached, it starts again at row 1 in the next blank column.

The data only contains 10 columns of data, so the limit of 256 columns in Excel won't be a problem.


Posted by mseyf on June 26, 2001 7:29 AM

If you have Access (or another database program), import the sheet into Access first, then you can cut and paste into Excel


Posted by Mark Headey on June 29, 2001 8:45 AM

When I had long files saved as ASCII I imported them into a word processor and cut them into two halves. The resulting sections were then loaded into Excel onto two sheets.