VBA delete from SQL DB syntax

[MikeL]

Hi,

Snippet of code that fails is bold in below. BTW INSERT INTO works. DELETE FROM (see below) does not.

--------------------------------------------------------------------------------------

'Opens connection to the database
cnn.Open ConnectionString
'Timeout error in seconds for executing the entire query; this will run for 5 minutes before VBA timesout, but your database might timeout before this value
cnn.CommandTimeout = 300

insertSQL = "DELETE FROM PAC(RIC)"

Debug.Print insertSQL
cnn.Execute insertSQL

cnn.Close
Set cnn = Nothing

 

[Trebor76]

Assuming you want to delete all the records from table "PAC(RIC)" your SQL statement would be as follows:

insertSQL = "DELETE * FROM PAC(RIC)"

You are missing the asterisk.

HTH

Robert