LINK WITHIN SQL STATEMENT 1

[ratnek]

This SQL statement works and connects on the fly to an external database:

SELECT * FROM ([ODBC;DRIVER={Microsoft ODBC for Oracle};SERVER=servername;UID=myID;PWD=myPassword].ownername.ExternalTable

I have lost the source example for this code. I want to link to an external Access database usin a UNC address (for example, "\\targetserver\RestofPath\myDatabase.mdb")

Does anyone know the SQL syntax to do this?

 

[bjd4jc]

You will likely want to look at the 'IN' clause if you're linking to Access.

Check out this recent thread222-1062571 for an example, albeit an append example.