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,'-',' ')
funzione replace non definita....
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: funzione replace non definita....
Which provider do you use in your connection string?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: funzione replace non definita....
Does it work if you use Microsoft.ACE.OLEDB.12.0 ?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36