How to Link to SQL Views from MS Access ADP

A

Altemir

I am able to link to external data residing in SQL Server tables, but I
can't seem to do the same with SQL server views. When I go to "Get
External Data ..." in MS Access and select "Link Tables ...", I only
see tables. Is there a way to link to SQL views?
 
S

Sylvain Lafontaine

Not sure to understand the question here but if I'm correct, you will have
to set a linked server and access your external views from there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Snowflake to SSIS 0
How to make linked tables to SQL Server views read only? 7
Access stripping decimal places in query 1
Cannot link to SQL server 17
SQL Server 6
I'm not able to select some specific tables from sql server intoAccess- santosh 2
link a table using an .ADP access application 1
What does linking a Access table to an SQL table mean? 2

Top