Unparsable Record Error

[Downie77]

I am getting this error when trying to load my excel spreadsheet into access. I am only getting it in on a column that is multiple choice on my table. The spreadsheet that I am going to load from will always have that column blank as it will be input later. What can I do about this?

 

[boblarson]

I am getting this error when trying to load my excel spreadsheet into access. I am only getting it in on a column that is multiple choice on my table. The spreadsheet that I am going to load from will always have that column blank as it will be input later. What can I do about this?

Import the spreadsheet into a transition table (what that means is just a table specifically for the spreadsheet) and then use an append query to move the data over to the live table (and not including that field in the append query).