INSERT INTO

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

Is there a way to run an insert into query and have the
destination tables be tables in a different database? If
so can someone please let me know how to reference these
tables?

Thanks,
Chad
 
Yes. You might use the IN clause, as in:

INSERT INTO
[Your Destination Table]
(
[Your Field 1],
[Your Field 2]
)
IN "C:\Your Folder\Your Other Database.mdb"
SELECT
[Your Table].[Your Field 1],
[Your Table].[Your Field 2]
FROM
[Your Table]

Alternatively, you might create a linked table in your database to the
destination table in your other database and then insert into the linked
table.
 
Back
Top