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.
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.- Lumbagohttp://xkcd.com/327/ |
|
|
|
|
|