Is An Import Errors table created during the import? If so, it might tell
you why the incoming rows failed.Also, could it be a primary key violation?
One of the most annoying things about importing an Excel sheet is that
Access looks at the first 20 rows to determine the data type of each column.
If a column is supposed to be text but the first few rows hold numerics, the
import will try to load that column as a number (long, int, decimal, etc.).
If that is the case, try moving a row with alpha characters in that column
to the top of the sheet, save it and then import.
