Web Development

Ask something
Discussion Locked

Access to SQL Field Conversion

0 helpful
3 replies

by rhizoned

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by jmiller1

ODBC may not be doing the type conversion correctly. Have you tried using DTS to import the table into SQL? This will allow you to choose your own conversion types, etc.

This discussion is closed to new replies.