Make table with 2 data sources

J

Jack

Hello all,

I'm hoping someone can tell me how I can use a single sql
statement to form a make table query that will select data
from one data-source and make the table in a second. Here
is something that may make this easier to understand:


Dim db1 As NEW ADODB.Connection
Dim db2 As NEW ADODB.Connection

Set db1 = CurrentProject.Connection
db2.Open "MyDSN"

db.Execute = "SELECT * FROM db2-Table INTO db-Table;"


So, in this example, I want to use a make-table query to
SELECT data from a table in db2 INTO a new table in db1,
all in a single sql statement.


Thanks to anyone who can help!

-Jack
 

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

Create Field with all the properties base from a table. 1
Comparing tables form 2 different database 1
Copy a table in an external database 1
Linking Tables from Password Protected DB 1
Appending Records from Table to Table 1
Access - Macro - table not exist 0
Can results of a Form be exported to a table on another database 0
table relationship messing up my link 11

Top