|9 can't find the field '|' Error when importing a csv to Access 2

[yyu1]

Hi, I was trying to import or link an external csv file to Access 2007 but
got the error message like this:
|9 can't find the field '|' referred to in your expression. You may have
misspelled the field name, or the field may have been renamed or deleted.

The csv file contains one field "Hour" as date/time and all other fields are
numeric.

I checked the field names and their values and could not find anything
wrong. I even deleted the headers from the csv file and re-import or re-link
to Access 2007, and the same error occurs.

However the same file was successfully imported to Access 2003 via linked
table on a different PC with only glitch that I have to change to Date/Time
to text for "Hour".

Thoughts and suggestions are appreicated.

 

[Clifford Bass via AccessMonster.com]

Hi,

Make a copy of the file and remove all but the header and first row.
Can you import it now? If so, it could be a problem with the data later on
in the file. You could also open it in Excel to see if all the data is
lining up correctly in the correct columns. While viewing it, are there
fields that change from numeric or date to character? Is there something odd
about any of the column names? Note that using Hour for a column name could
lead to issues as Hour() is a function in Access.

Hope this helps,

Clifford Bass