I have a DB, and have updated some of the tables in the new version, some of which have extra fields.
when i deploy this DB i need to be able to copy all the old data from the previous version into the new DB.
Is there a way this can be acheived with VBA.
I will need to be able to get the user to select the Backend from which the data will be imported.
Once the import is done, the db will have to check to see if an import has been completed and if so carry on loading.
Many Thanks in advance