I have two Access databases (mdb1 & mdb2) that are accessed via ODBC. Both mdb's are in different directories and nether one is in the VB default directory.
I need to know the most efficient way to code for opening each database and reading every row from a table in the first database (mdb1.table1) and writing the rows to a table in the other database (mdb2.table2).
I have tried several ways and they have proved unsuccesful.
Someone told me to open mdb1 and read table1 into an array in memory and then open mdb2 and write from the array.
I am not sure if this is the correct approach or how to do it if it is.
Any advise would help.
Thanks!
I need to know the most efficient way to code for opening each database and reading every row from a table in the first database (mdb1.table1) and writing the rows to a table in the other database (mdb2.table2).
I have tried several ways and they have proved unsuccesful.
Someone told me to open mdb1 and read table1 into an array in memory and then open mdb2 and write from the array.
I am not sure if this is the correct approach or how to do it if it is.
Any advise would help.
Thanks!