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".