Add an Excel file as a linked server in SQL 2012

Posted by MgSam on Server Fault See other posts from Server Fault or by MgSam
Published on 2014-06-03T22:08:08Z Indexed on 2014/06/11 15:29 UTC
Read the original article Hit count: 250

Filed under:
|
|

I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you to use 'Microsoft.Jet.OLEDB.4.0', is not present in 2012 from what I can tell.

Can anyone tell me which provider I need to use and what the product name, data source, and provider string should be?

For reference, this is the screen I'm looking at:

enter image description here

Thanks.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2012