Transfer data from DB1 to DB2

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

I am Having T1 under DB1 and T2 under DB2

Field in T1 say [F1] - Text and in T2 say [F2]- Text.

From the above field names are different but data type is
same.

Now I want to transfer data from [F2] to [F1]

Kindly help.

Krish
 
I am Having T1 under DB1 and T2 under DB2

Field in T1 say [F1] - Text and in T2 say [F2]- Text.

From the above field names are different but data type is
same.

Now I want to transfer data from [F2] to [F1]

Kindly help.

Krish
Click to expand...

Open DB2. Use File... Get External Data... Link to link to T1 in DB1.

You must have some field in T1 and in T2 to serve as a link between
the tables; without this field Access cannot tell which of the many
values in F2 should replace the value in F1. Create a Query joining
the tables on this field (whatever it is).

Change the query to an Update query. On the Update To line under T1.F1
put

=[T2].[F2]

Run the Query using the ! icon.
 
Back
Top