I need to copy the data from a table in one database to the same table in another database using VBA
I cannot export the table using Access 2016 because that requires the deletion of Relationships.
So, if I have tbl_Data in my source database (DbS) and tbl_data in the CurrentDb, I would like an SQL statement like
INSERT INTO tbl_Data SELECT * FROM (C:\Temp\DbS\tbl_Data)
Despite many attempts I have not managed to construct the FROM clause as shown
Alternatively, I could set the DbS path as a String as strSource = "C:\Temp\Dbs" which could be incorporated into the SQL, however, I don't then know how to reference the tbl_Data.
Any help gratefully received.