Get data from external database/query into current database

[GGROD]

is there a way to run a query in an external database and put the results into a table in my current database?

Example:

INSERT INTO tblLocalTable
SELECT *
FROM (ExternalDatabase.mdb, externalQuery)
?

Thanks

 

[bubba100]

Why not link to the tables of the other db?

 

[GGROD]

If I could link to the external query then I would do that. But access doesn't allow to link to queries just tables. The external query I need data from is very complicated and complex and I think it would be very difficult to duplicate.

 

[Golom]

Try

INSERT INTO tblLocalTable
SELECT * 
FROM (;database=C:\Somepath\ExternalDatabase.mdb).ExternalQuery

 

[GGROD]

Don't I have to open a connection to the external database first?