How to Overwrite Existing Records Using Import of TransferSpreadsh

T

ttp

When using a TransferSpreadsheet action in a macro, how do you overwrite
existing records instead of appending to the table? Once the macro is
complete, I would like for only the header fields to remain (no data). Is
there a means to delete the records (not the table) at the end of the macro
execution?
 

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

TransferSpreadsheet macro, to Overwrite data not Append To Bottom 3
How to count table records in a macro 1
New macro doesn't update existing records 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Office 2007 TransferSpreadsheet Import 5
Import Overwrite Data in Table 3
Disable Make-Table Overwrite Prompt 1
Export report to rtf, auto overwrite existing file, & NOT open MS 2

Top