SQL Query Using Table In Another Database ?

[The Brown Growler]

Hi,

Is it possible to have an SQL query that obtains field values from a table in another MS Access database, if so, could anyone please assist with the syntax required for the FROM clause ? I have tried various options to try to reference the other database using path locations on my hard drive etc but no success as yet.

Also, is it possible to do the same thing using the query grid via drag and drop rather than have to use an SQL specific query ?

Thx

 

[jal]

Hi,

Is it possible to have an SQL query that obtains field values from a table in another MS Access database, if so, could anyone please assist with the syntax required for the FROM clause ? I have tried various options to try to reference the other database using path locations on my hard drive etc but no success as yet.

Also, is it possible to do the same thing using the query grid via drag and drop rather than have to use an SQL specific query ?

Thx

I don't know how to use the query grid, but the syntax for the editor is:

Select * From Contacts in "C:\Contacts.MDb"

Maybe someone else can help you with the query grid.

 

[khawar]

Download the zip file it contains two files

copy the file be in your C drive and file fe any where

now open file fe and check query1

this query takes data from be file in your c drive

Regards

Khawar