Transfer data from DB1 to DB2

[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

 

[John Vinson]

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

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.