| 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 | |||
Hybrid Mode
