Hi I'm running an openrowset select to a network folder and it work ok when I execute the statement from the SSMS on the SQL server, but when I execute the statement from another PC and using the same user is giving me the following error:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
below a fragment of the statement
SET @SQL = '
SELECT
[Pay Group],
[Pay Date]
FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',
''Excel 12.0;Database='
+ @Path
+ @filename
+ ';HDR=YES'',
''SELECT [Pay Group],
[Pay Date] FROM ['
+ @sheet +
'$]'')'
PRINT @SQL
EXEC(@SQL)
How to resolve this situation?, as I need to be able to execute the same statement from the SSMS installed on my PC not connected via RDP to the SQL Server machine.
Thank you in advance!!!!!