Connection String in query SQL

[Galaxiom]

There is a way to query a table in a remote database where the connection string is included as part of the SQL text.

Could someone please remind me of the syntax.

 

[MarkK]

I don't know about a full-on connection string in Jet SQL, but there is the IN clause, here

Here are more IN clause examples, as linked to from the previous link.

And there always connectionstrings.com.

Cheers,

 

[Galaxiom]

Beginning to think my imagination got the better of me.

It was a long time ago when I thought I saw it. I didn't know much then and it was probably just an IN clause which looked really impressive to me at the time.

Now I know more but neglected to rescale my sense of awe when trying to recall what I had seen.

Probably merged the memory of the Connection String in a PassThrough query which I heard about around the same time.

 

[Galaxiom]

Not my imagination after all. I PMd Banana who I decided had posted the original. This is what he replied:

You mean when we want to connect to an ODBC object that's not linked but using Access engine? We usually do that for heterogeneous operations.

Two possible syntax:

SELECT ... FROM aTable IN [ODBC;...];

or (I prefer this one)

SELECT ... FROM [ODBC;...].aTable;

The latter syntax allows you to perform a query on two different tables in different ODBC database and join them using Access. However because it's Access that has to perform the join, the performance may be quite slow so it's sometime useful to compare to downloading them into local Access table and performing work against local temp tables instead.