I am trying to Automatically import an excel spreadsheet into an existing Access database using VB code. I am using the docmd.transferspreadsheet method and it is working, however I need to make sure there are no duplicates when importing-either in the access database or the excel spreadsheet...
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.