googling... but is possible to use external db in query?

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

googling... but is possible to use external db in query?

Post by sal21 »

But possible:

pseudo code

... select IDNAME from in c:\miodb.mdb\table1 where ...

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: googling... but is possible to use external db in query?

Post by HansV »

You can use

... SELECT IDNAME FROM Table1 IN 'C:\miodb.mdb' WHERE ...

The path and filename of the external database must be enclosed in single quotes.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: googling... but is possible to use external db in query?

Post by sal21 »

:cheers:
HansV wrote:
21 Mar 2021, 19:29
You can use

... SELECT IDNAME FROM Table1 IN 'C:\miodb.mdb' WHERE ...

The path and filename of the external database must be enclosed in single quotes.