it usu imports exactly as it is in the spreadsheet. The 2nd row enters the table as 2nd row, as is, no sort.
because its an error , it cant show the field.
NOW, what happens is, Access gets confused on what data type it is. The 1st 10 values of a field may be a number so it assumes number, but then 11th is a string, which is an error since access already created the field as numeric.
i correct this by setting EVERY item in the excel field to string. Before import i run a macro that scans the field putting a single quote in front of every value. Save, then import.
This fixed 99.99% of my errors.
Code:
'this is ONLY for items in every row
Sub Cvt2Text()
While ActiveCell.value<> ""
if left(activecell.value,1)<>"'" then ActiveCell.value= "'" & ActiveCell.value
ActiveCell.Offset(1, 0).Select
Wend
End Sub