Delete Table using macro

  • Thread starter Thread starter Alison
  • Start date Start date
A

Alison

I would use deleteobject object type is table and then
object name is the table name.

Hope this is what you are after.

cheers

Alison
 
Alison said:
I would use deleteobject object type is table and then
object name is the table name.

Hope this is what you are after.

cheers

Alison
Click to expand...

hello,
i have a question regarding the deleteobject macro. is it possible of
deleting only the data and not the object/table? would it be better
to create an update query and vb instead of a macro??

thanks in advance,
jmcn
 
JMCN,

You can use a Delete Query for this, and you can use the OpenQuery
action in a macro to run the Delete Query.

- Steve Schapel, Microsoft Access MVP
 
Steve Schapel said:
JMCN,

You can use a Delete Query for this, and you can use the OpenQuery
action in a macro to run the Delete Query.

- Steve Schapel, Microsoft Access MVP
Click to expand...

Steve,

Thanks for the advice. I created the delete query and used the
OpenQuery action in the macro to run the Delte query:) Then the next
step is importing the data from Excel to Access, which works out
perfectly well with TransferSpreadsheet action in my macroImportExcel.

Thanks again!!!
JMCN
 
Back
Top