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
 SQL Server 2012 Forums
 Transact-SQL (2012)
 accessing access db from sql 2012

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-03-10 : 07:16:36
I need to join in a query a table from an access database

what is the best way to do this

I am trying

SELECT * FROM OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\db2.mdb"')...customers


I am getting
Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2014-03-10 : 07:22:40
http://www.excel-sql-server.com/excel-import-to-sql-server-using-linked-servers.htm
Go to Top of Page
   

- Advertisement -