Are you sure you've formatted the entire excel columns correctly before importing?
When importing an excel file, MSAccess likes to interpret what the field type is by what the values are in the first row of the excel sheet. For example, if the 1st row of Column B in the excel sheet is a number and the 2nd row of column B in the excel sheet is a text value, MSAccess might interpret that field (when importing as an integer type) which would give you errors on the text values.
Also check for bad date type values. A date value of 3/69 versus 3/1/2010 would cause problems when importing and MSAccess interprets this as a date type field.
Since your problem is limited to certain values (not entire columns or fields), I'm guessing it has something to do with the formatting in excel of those fields.
You can also try linking to the excel file to see if this changes anything with the #Num error. If all data looks ok in the linked excel table, then use a query to append the data to an MSAccess table (or try a make-table query).
Last edited by pkstormy; 04-09-10 at 23:04.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)