Connect to an MS Access Database from SQL Management Studio
--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Hypnotic Orient Looping
--
Chapters
00:00 Connect To An Ms Access Database From Sql Management Studio
00:15 Accepted Answer Score 11
00:34 Answer 2 Score 4
00:48 Thank you
--
Full question
https://superuser.com/questions/51777/co...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftaccess #sqlmanagementstudio
#avk47
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Hypnotic Orient Looping
--
Chapters
00:00 Connect To An Ms Access Database From Sql Management Studio
00:15 Accepted Answer Score 11
00:34 Answer 2 Score 4
00:48 Thank you
--
Full question
https://superuser.com/questions/51777/co...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftaccess #sqlmanagementstudio
#avk47
ACCEPTED ANSWER
Score 11
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/
ANSWER 2
Score 4
You can also import the data into an existing database, via Tasks > Import Data. You can then select into which tables (new if desired) and how to map the columns