Another trick for bypassing unknown error on Access data import

So I was just trying to import some data into an existing table, and I get unknown error. The existing table had two fields I was importing, one is a varchar, the other an int. The file I’m trying to import was an excel file, but I suspected that Access was interpreting the field that would be the varchar as a float. So I added a line at the top of the file, put a word into the nvarchar field, and a value into the int field and tried the import again – success!

Related posts:

1. Another trick for avoiding an Access import error
2. Avoiding errors when importing data into Access.
3. Access import trick: Make sure columns are wide enough
4. Another Access Trick
5. Access data import is idiotic

Tagged as: Access, Excel, import data, Subscript out of Range, Unknown Error