Home » Questions » Computers [ Ask a new question ]

Connect to an MS Access Database from SQL Management Studio

Connect to an MS Access Database from SQL Management Studio

I want to connect to an MS Access 2003 DB from SQL Management Studio 2005 so I can run queries on the Access DB from SQL Management Studio.

Asked by: Guest | Views: 63
Total answers/comments: 1
Guest [Entry]

"There are two ways to do this:

Add the MDB as a linked server

http://msdn.microsoft.com/en-us/library/aa213778%28SQL.80%29.aspx
Enable Ad Hoc Queries in SQL Server and use OpenDataSource

http://riteshshah.wordpress.com/2009/03/02/read-xls-or-mdb-file-with-opendatasource-sql-server-2005/

http://support.microsoft.com/default.aspx?kbid=266008"