Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In EXCEL, access denied when deleting read only | Excel Discussion (Misc queries) | |||
Deleting Records in a table | Excel Discussion (Misc queries) | |||
Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming | |||
Deleting records from access using ADO in through Excel | Excel Programming |