Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connect MS Access Table to SQL Server 2005 Query

Author  Topic 

sqlslick
Yak Posting Veteran

83 Posts

Posted - 2010-01-21 : 23:19:38
Hey guys,

I know you can connect a Microsoft Access 2007 database table to a SQL Server 2005 table, view or stored procedure through a SQL Server OLE DB driver or SQL Native Client (SNAC). Anybody know if you can connect a SQL Server 2005 query to a Microsoft Access 2007 database table?

Thanks again for your help!

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-01-22 : 03:07:30
Look up "openrowset" in Books Online...it's basically the same thing.

- Lumbago
http://xkcd.com/327/
Go to Top of Page
   

- Advertisement -