What is the best way to do this? In the Help file examples, I do not see a syntax defined for a Datasource Moniker using SQL. I do see a UDL file type, but there is no example syntax and I cannot get this to work.

Ok. I figured out my own problem. Of course I will share...


For those of you trying to Import/Link directly to a SQL Table or View instead of using MS-Access as the "middleman". First create a UDL file that points to your SQL database (I use the ODBC DSN method). Here is the syntax for the code to link:

LinkData("C:\My_Data.UDL!My_Table", "ID_Field")

The part I was having a hard time with was the after the "!". You must specify the name of your SQL table or view here. Hope this helps.

Thanks for the follow up.

Eric