create an excel link server in sql server 2008

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  September 11, 2011 at 2:02 am

  #256977

  I am trying to create a linked server within my instance of SQL Server 2008 to an excel 2010 spreadsheet. I have tried using the following code but get the error message

  EXEC sp_addlinkedserver @server = N'ExcelDataSource',

  @srvproduct=N'ExcelData', @provider=N'Microsoft.ACE.OLEDB.12.0',

  @datasrc=N'c:\Temp\oo.xlsx',

  @provstr=N'EXCEL 12.0' ;

  error message:

  OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelDataSource" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

  Msg 7399, Level 16, State 1, Line 1

  The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelDataSource" reported an error. Authentication failed.

  Msg 7303, Level 16, State 1, Line 1

  Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelDataSource".

  what do i do?please guide me immediatly.thanks

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 11, 2011 at 3:35 am

  #1379673

  If the Workbook already open?

  Does the Account trying to Access it have Share and NTFS Permissions.

  Could be a Firewall Issue.

  Check out the article for it may have some items that you can at least rule out.

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109394

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/