I am using an excel file to run queries on my database. I originally had it as a linked table, but when you split the database it won't allow people to run queries at the same time because of the excel file.
So I am trying to make a macro using the 'ImportExportSpreadsheet' macro and putting the data into a local table instead. I feel like this should work, but every time I do it re-adds the data to the table and I end up with double the amount of entries (duplicates). I need to do the import every time because the data in the excel file is constantly changing.
My question is, is there is a way to create a macro that will import a spreadsheet each time a query is run and avoid getting massive amounts of duplicates. My first thought was to add a delete query to the macro and just immediately delete the duplicates but I wasn't sure how to go about that.
Thanks for reading, and thanks for any help.
So I am trying to make a macro using the 'ImportExportSpreadsheet' macro and putting the data into a local table instead. I feel like this should work, but every time I do it re-adds the data to the table and I end up with double the amount of entries (duplicates). I need to do the import every time because the data in the excel file is constantly changing.
My question is, is there is a way to create a macro that will import a spreadsheet each time a query is run and avoid getting massive amounts of duplicates. My first thought was to add a delete query to the macro and just immediately delete the duplicates but I wasn't sure how to go about that.
Thanks for reading, and thanks for any help.