PDA

View Full Version : [SOLVED:] VBA to Link SQL View Into Access Database


jo15765
04-22-2014, 11:15 AM
How would I link a sql view into my database? I have found code to do a table, but no code to do a view?
Bob Phillips
04-22-2014, 11:54 AM
Write a query and use that? A query can span multiple tables.
GP George
04-26-2014, 08:49 PM
You can link to views in SQL Server just the same way you do for tables, if that is your question. I assume what you are asking about is ODBC linking from Access to SQL Server. If that is not correct, please provide more details on what you need and the environment in which you are working.