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.
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.