Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to link a table to SQL Server view?

Status
Not open for further replies.

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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top