1. The TransferSreadsheet method should do the trick. It is much safer to first import the worksheet into its own table. then you want to append the records to an existing table.
2. Use the DELETE DML avaliable in Access. in the next example, I will delete all the records in my customer...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.