funzione replace non definita....

[sal21]

SQL = "UPDATE " & TABELLA & " SET " & TABELLA & ".COMUNE = Replace(" & TABELLA & ".COMUNE,'-',' ')"
Debug.Print SQL
CN.Execute SQL, K, adCmdText + adExecuteNoRecords

in debug.print

UPDATE [01-PIEMONTE] SET [01-PIEMONTE].COMUNE = Replace([01-PIEMONTE].COMUNE,'-',' ')

[HansV]

Which provider do you use in your connection string?

[sal21]

Which provider do you use in your connection string?

ADO JET 4

[HansV]

Does it work if you use Microsoft.ACE.OLEDB.12.0 ?

[sal21]

Does it work if you use Microsoft.ACE.OLEDB.12.0 ?

Ok. I chenge connection.
Tks

[sal21]

Does it work if you use Microsoft.ACE.OLEDB.12.0 ?

WORK!
TKS