469,275 Members | 1,540 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

SQL View of MS Access

Is it possible to create a View in MSSQL that will pull data from an MS Access database?

I know you can go the opposite direction, link to a SQL View through Access, but can you go the other way with it?
Aug 16 '07 #1
1 1053
Sure. Theres probably lots of ways to do it.

I would use the MS Jet provider, but I've seen it done using the OLE DB provider.

I created a test.mdb on the root of my SQL server. In that MDB I created a simple table called tblTest. Here's how I selected from that table.

Expand|Select|Wrap|Line Numbers
  1. Select * 
  2. From OpenRowset('Microsoft.Jet.OLEDB.4.0', 
  3.    'C:\Test.mdb';'admin';'', tblTest)  
Aug 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Robert Stearns | last post: by
1 post views Thread by Chad Reid | last post: by
2 posts views Thread by abefuzzleduser2 | last post: by
104 posts views Thread by Beowulf | last post: by
2 posts views Thread by Shirley | last post: by
3 posts views Thread by mnjkahn via AccessMonster.com | last post: by
2 posts views Thread by existential.philosophy | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.