Deleting An Access Table

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

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
 
Charles said:
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
Click to expand...

Try:

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

Jamie.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel macro 1
Delete Tables 2
How to export table from outlook into ms access table? 0
Problem with access acImportDelim importing csv with headers 1
Manipulating MS Access records with excel VBA + ADO 7
Delete Table from Excel 2
Return Primary Key 1
Excel Export Filtered Form Data To Excel 0

Back
Top