I import an excel file into a database once a week. I use a macro with TransferSpreadsheet in the action column to import the spreadsheet into a table. This works fine except that it always appends to the existing table, so I have to remember to first delete the existing table before importing.
I would like to just overwrite the existing table.
Can I do this using the macro or is there some code I could use with a command button?
Thanks.
Start Free Trial
