Type conversion error when using the Append Query

V

Van T. Dinh

Not sure but try using one of the functions CInt(), CLng
(), CSng() or CDbl() which matches the data type / size of
the target Field.

Also, *make sure* all values in the source Field can be
converted to numeric values. You may need to use the
IsNumeric() to check them out. Try a query like:

SELECT *
FROM YourLinkedExcelSpreadsheet
WHERE IsNumeric([SourceField]) = False

which will show rows that the SourceField values cannot be
converted to numeric values.

HTH
Van T. Dinh
MVP (Access)
 
Top