SQL View of MS Access

[blechner]

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?

[bwestover]

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.

Select * 
From OpenRowset('Microsoft.Jet.OLEDB.4.0', 
   'C:\Test.mdb';'admin';'', tblTest)