Importing or Linking Excel worksheet to Access as a table coming back with errors
I have a comma delimited txt and csv versions of a data set I am trying to either import or link in a MS-Access 2010 database. The data set has over 100,000 lines. This database was created in a pre-2003 version of Access but I have saved it to a 2010 version.
When I try to import the external data to the database, the 3rd field, FundCenter, does not copy over and I get NULL's at row 8550. I have tried both the txt and csv versions of the data set and get the same result. I have gone into the csv version and set the column to text without any success.
I am trying to set up a macro to import the data automatically but if I cannot get it to work manually the macro is a mute point.
I have attached the txt file. Can someone take a look and see what I need to do?