SQL Query to copy Data from One Table to another Table having same names but from different database

A

apurv.agarwal

Hi friends,

I would like to know about the SP(Stored Procedure) or a SQL Query
which will copy data from:

DB1 -> tbl_alm3 TO DB2 -> tbl_alm3

The structure of Tables in both DB is same.However DBs are different.

Kindly let me know the best and simple way to do so.

Thanks
 
J

Jeff Boyce

You could create an append query to copy data from one table to another,
provided both tables were either local to the database and/or linked.

But I'm curious why you have two tables with identical structure between
which you are copying records? If you'll post a description of why you have
chosen this solution (i.e., why are you doing this), the newsgroup readers
may be able to offer an alternate approach, possibly one that doesn't result
in two copies of the same data (a problem for synchronization).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding New Record to a linked table from Query 1
Schedule Update Query 1
connect to multiple odbc in pass-through query 1
How to transfer data from database to another database? 6
"Query Too Complex" Access 2000 help me make this one query less complex? 0
Update table with values from another table 2
Capturing data from two tables... 5
Make Table Query to external ODBC SQL Server database 17

Top