I have an Application with the code in the Front End and the data in a Back End DB. i.e. NEW-DB The tables in this database are all defined in the application.
I also have old data (Back End DB without code). i.e. OLD-DB. The tables in the NEW-DB and OLD-DB may have the same name but with a different structure.
I want to run code in the Front End Application to extract the data from the OLD-DB, massage it and write it to tables in the NEW-DB.
How do I access the tables in the OLD-DB? What is the syntax for Access VB?