Nov 12, 2007 #1 mk2008 Programmer Nov 12, 2007 1 CA Hi, I want to know how to link a table to SQL Server view with VBA code. Thanks Alex
Nov 13, 2007 #2 JerryKlmns IS-IT--Management Feb 7, 2005 2,062 GR mk2008 If you want to get the result from a View you should create a Pass Through Query SELECT * FROM yourViewNameHere; For the ODBC Connect Str of its properties you should use the ODBC connection string that mikej336 says. Upvote 0 Downvote
mk2008 If you want to get the result from a View you should create a Pass Through Query SELECT * FROM yourViewNameHere; For the ODBC Connect Str of its properties you should use the ODBC connection string that mikej336 says.