Hi Rick, Alex

i have imported data from Excel into Access. Normally if there is an import error, a table is created automatically that shows me the field name and the row number where i can find the error.
I have however noticed that sometimes i get a Type Conversion Failure and they point me field name say F27 or F21 in row 11. However, i dont have F27 or F21 as field names in my Excel file. Do they have another meaning? Where do i find the field name that they are pointing me to?
infact, two error tables were created automatically: PtFollowUpT$_ImportErrors and PtFollowUpT$_xlnm_ImportErrors. Both point to the same row numbers but one says the field in question id F21 and another F27.

MICAH

---

Reply from Alex Hedley:

Could it not just be that column number?