This would be no problem if the files where in Excel, but I have not been able to make this work with an Access file.
I have a macro for csv files that does almost exactly what I need. With a few modifications, I was able to open the tables in Excel, but could not figure out how to get the data back into the original file.
Here is what I am trying to get the macro to do:
1. Open each mdb file in a directory. (Each file contains several tables).
2. Copy the data from column 3 in table "RQ", paste that data to column 26 in table "ID".
3. Then copy the data from column 15 on table "ID" back to column 3 in table "RQ".
4. Then save the modified mdb file to a new location and delete the old mdb file.
I have a macro for csv files that does almost exactly what I need. With a few modifications, I was able to open the tables in Excel, but could not figure out how to get the data back into the original file.
Here is what I am trying to get the macro to do:
1. Open each mdb file in a directory. (Each file contains several tables).
2. Copy the data from column 3 in table "RQ", paste that data to column 26 in table "ID".
3. Then copy the data from column 15 on table "ID" back to column 3 in table "RQ".
4. Then save the modified mdb file to a new location and delete the old mdb file.