Hi All
I need to be able to import a table (tbl1A) from database A to a table (tbl2B) in database B.
The problem is that database A and B are different versions of the same database - and therefore the tables are the same, just with different data. I need to update the data in tbl2B with the data from tbl1A.
This is likely to happen alot and so I need to write some code around it. The access import/export does not work as the tbls have relationships with others in the database.
I'm thinking that I will import the table from dbA (manually) and then copy the data in using VB. The problem I foresee is that one of the fields (the one that is in a relationship with another table) is an autonumber field.
has anyone done something like this before? - can anyone suggest a solution?
Many thanks
Scube
I need to be able to import a table (tbl1A) from database A to a table (tbl2B) in database B.
The problem is that database A and B are different versions of the same database - and therefore the tables are the same, just with different data. I need to update the data in tbl2B with the data from tbl1A.
This is likely to happen alot and so I need to write some code around it. The access import/export does not work as the tbls have relationships with others in the database.
I'm thinking that I will import the table from dbA (manually) and then copy the data in using VB. The problem I foresee is that one of the fields (the one that is in a relationship with another table) is an autonumber field.
has anyone done something like this before? - can anyone suggest a solution?
Many thanks
Scube
