Add data from one DB to another

[grassaj]

I would like to use a SQL statement to add data from one database, DB1, into a table in another database, tblData in DB2. What is the best way to do this? It seems there are many choices that I've read of so far- the IN statement, INSERT, INTO, etc. Thanks!

 

[WildHare]

Actually, I wouldn't necessarily recommend this, as it can raise data synchronization problems later on. You might find it just as useful to LINK to the other table, and if you don't need all the fields in it in your view, just write a select query to view what you want, in any order you want. This way, your view of the other table will always be current and up to date.

Jim Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com