How to use INSERT INTO (Currency Value) + SELECT (String Value) SQL DB Access

Asked

Viewed 157 times

0

I’m trying to insert some data into a format column Currency, but the data is String. I tried to make the conversion using the Convert(Dados_String, Currency), but it didn’t work either.

Follow the command:

INSERT INTO Tabela1(Dados_Currency)
SELECT Convert(Dados_String, Currency)FROM C:\Users\Servidor\Desktop\DBs\DB2.Tabela2)

Error:

Err: -2147217900 Indefinite Convert function in expression. Query: INSERT INTO Table1(Data_currency) SELECT Convert(Data_string, Currency) From (C: Users Desktop Server Dbs DB2.Table2)

sql ms-access

  • Would not be SELECT Convert(Currency, Dados_String)?

  • I always used it the other way, but just in case I took the test the way you quoted it, and it made the same mistake.

No answers

Browser other questions tagged sql ms-access

You are not signed in. Login or sign up in order to post.