Hi folks! I'm a little stuck here and cant wrap my head around what to do.
All help is greatly appriciated!
- So, i have 3 excel files that are being posted daily (files are replaced with updated ones).
- The data in these excel files is imported into tables with a macro.
First the macro deletes the old 3 tables, then imports the new on startup!
The problem is:
When someone is already logged on, and someone else start the program, it gives an "exclusive" error. Logically because it cant delete the tables because they are being used.
What is the best approach here? I wish it would just ignore the whole thing and just import. When i dont used the "delete tables" macro's, it will build up a whole bunch of duplicates.
How can i import excel files into tables on startup (like i have) without duplicates? And will i still have the same exclusive error??
I would like to hear what you lads n lassies think