ExcelBanter - Deleting An Access Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Deleting An Access Table (https://www.excelbanter.com/excel-programming/312931-deleting-access-table.html)

Charles

Deleting An Access Table

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
TIA
Charles

Jamie Collins

Deleting An Access Table

"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.

--

All times are GMT +1. The time now is 10:27 PM.