I have four excel files that have the same columns in the same order and very similar data. The only difference between these four files that these four files came from four different regions of our company. Each file has approx. 150 columns and anywhere from 30000 to 55000 records.
I wanted to import these files into Access, as one combined table to make this data managable. The first two files imported easily, using the Access Import Wizard. Each file created an error log which contained some "type conversion" errors, but a too few records to worry about (less than .02%).
The other files were very problematic and would not import into Access. I attempted to clean up the data by making sure that each text field had 255 or fewer characters. This allowed me to import the tables; however the error log showed "Unparsable Records" and there was a significant number of errors - average of one error per record. I tried to determine if just a few fields were problematic, however the affected fields are all across the board.
I started to double check the records in Excel and the new Access table. Most of these records are one worded fields (ie Yes or John Smith). Nothing legthy or with unusual characters.
Any idea why I am getting these errors or how I can prevent them?
Thanks in advance for your help!