I'm working on a database which holds all the courses each of our user sfollowed in the past.
We already have a (third-party) database (let's call it dbBought) containing all the needed user-information (name, user-ID, ...), but I'm not allowed to modifiy anything in this database.
So I created a new database (let's call it dbOwn) with several tables and I planned to import some tables of dbBought.
But because dbBought is daily updated, I want to import the needed tables everytime I start up my database. How can I do this automatically?
PS: I intended to link the tables instead of importing, but we had a discussion with the third-party db-supplier because we had a lot of problems with that db and the supplier said it was because of the linking.
So linking is not an option anymore.
Just call the function from the Autoexec macro and it will run on startup.
Do bear in mind that this does not check if the table exists. If you are just importing the whole table data, it won't matter. However if you are adding data from source table to destination table, it will overwrite what is already there. If the latter is the case, I would suggest you import to a temporary table, then copy the required data to the correct table.