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