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
