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

0

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)

    
asked by anonymous 16.04.2015 / 17:28

0 answers