Transfer data from DB1 to DB2

  • Thread starter Thread starter KRISH
  • Start date Start date
Krish,

It depends on how many tables you have, if the tables in DB1 and DB2 have
the same structure, whether you want to append data from DB1 to DB2 or just
copy the tables.

You can import tables from DB1 into DB2 if the tables are to be exactly the
same using the File -> Get External Data menu option.

You can even use cut and paste if the table structures are the same.

If you want to append data from DB1 to DB2 then you can link the tables from
DB1 to DB2 and use an Append query. (You will have to join the tables to do
this if some data is already in DB2.) This allows you to copy some or all
of the fields.

You can automate this process using VBA code if there are many tables.
 
Any one help me how to transfer data from DB1 to DB2.

Thanks in advance.

Krish
Click to expand...

Krish, you'll need to post a fair bit more detail. Are DB1 and DB2
separate Access databases - .mdb files containing tables, forms,
reports and so on? or are they two tables within a database? or two
tables in separate databases?

And what kind of transfer do you mean: import a Table from one .mdb
file into another? If so: File... Get External Data... Import. Add
records from table DB1 as new records in table DB2? If so: an Append
query. Update fields in DB1 to fields in matching records in DB2? If
so: an Update query.

Post back with a clearer question and we'll try to give a more
specific answer.
 
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
 
Back
Top