Linked server issue

• zak.lewis

  Old Hand

  Points: 372

  More actions

  March 31, 2015 at 2:24 am

  #299097

  Hi there, this is the first time I'm setting up a linked server and I run into weird issue. When I test the source locally using the Management Studio on the actual server the connection is good and I can retrieve the data from the Excel file. But when the query or connection test is run via remove Managment Studio (on my desktop machine) I get the following error:

  Msg 7399, Level 16, State 1, Line 3

  The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "EXCELMACRO" reported an error. The provider did not give any information about the error.

  Msg 7303, Level 16, State 1, Line 3

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

  I have full sysadmin access, can anyone help?

  Thanks,

  Zak

• Sigerson

  Hall of Fame

  Points: 3697

  More actions

  April 7, 2015 at 1:37 pm

  #1789320

  Are you able to Import the Excel file into a temp table?

  ( Right-click on [Database Name]-->Tasks-->Import... )

  Trying that might expose if there's some kind of error in the Excel file.

  Sigerson

  "No pressure, no diamonds." - Thomas Carlyle