Importing Text file to Excel error

[cjonovic]

Hello,

I am currently trying to create a new database using MS Access. The text file that I am given comes from a program which the company uses, and I need to correct some data on the records first. I have been importing the text files by city into a spreadsheet, doing my editing, then importing into a master database.

This worked for two of the cities. However, when I got to a major city, it capped the text file input in Excel to 66000+ cells only (I forget the exact number).

Without having to go area by area of the city, is there a way that I can bring out more information from the text file or does Excel cap at that number of available cells? Any input will be very useful.

Thank you.

 

[Joe4]

Excel can only hold 65536 rows per sheet.

In the next version, that number will increase significantly.

 

[Seti]

Welcome to Mr. Excel.

Excel limits the number of rows to 65,536. There is some code around the board somewhere if you search for it that will take the first 65,536 rows and put then on sheet1, the 2nd 65,536 and put them on sheet2, etc. However, since Access doesn't have this limit, can you load the data directly into Access and do your editing there?