I'm trying to insert some data into a Currency
format column, but the data is String
. I tried to convert using Convert(Dados_String, Currency)
, but it did not 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 Undefined 'convert' function in expression. Query: INSERT INTO Table1 (Data_Currency) SELECT Convert (DataString, Currency) From (C: \ Users \ Server \ Desktop \ DBs \ DB2.Table2)