copying content of one database to another

[MrSandman666]

Hi everybody.
Let's say I have two databases (DB_A and DB_B). Let's also say that DB_A contains a couple of tables and these tables contain data. Now, I want to copy these tables with all their data to DB_B.
Seems like a simple operation but I can't find any documentation about that. Is there a way to this, without having to do it by hand? It's really a lot of data.
And please explain everything as simple as you can. I'm rather new to SQL.

 

[JoeMiller]

Can't you just import the tables? Two ways:

A) Go to File-->Get External Data-->Import Tables and bring the tables by selecting DB_A and then the tables you want to import.

B) Look up "TransferDatabase (type it in to the assistant) and read how to do it in VBA. It's a simple procedure if you need to do it in code.

HTH Joe Miller
joe.miller@flotech.net