"Charles" wrote ...

How can I delete an access table using VBA From Excel, I
have tried
set db = dao.dbEngine.opendatabase(dataPath)
db.TableDefs.Delete TableName
This will only delete Linked Tables

Try:

<<connection.Execute "DROP TABLE " & TableName & ";"

Jamie.

--