Access to SQL Field Conversion

I have a file that is imported from a text file into an access table.

I have to append new information to a sql table with a number of Money data type fields via ODBC.

I get the msg “Disallowed implicit conversion from data type “Varchar” todata type “money”.

The field is of type Currency and not Varchar. Everything i have read up to this point explains that Currency is the equivelent of Money.

Does anyone know what is being done wrong?

Thanx

David