Using the TransferSpreadsheet macro command to import data from an excel worksheet, but target table is being appended, I want it to replace. Can that be done with this command?
Using the TransferSpreadsheet macro command to import data from an excel worksheet, but target table is being appended, I want it to replace. Can that be done with this command?
Last edited by bdaniel; 11-21-2010 at 09:49 PM. Reason: Correction
Here is a thread that might help you follow the link:
https://www.accessforums.net/program...heet-6317.html