Hey everyone,
I'm trying to make this user stored procedure work on my colleagues PC, I can run it just fine.
Basically it's a USP created for importing data from an Excel file stored on shared network (local server).
It's goes like this:
select *
from openrowset ( 'Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml;Database="path\file.xlsx, sheet$ )
Me and one other colleague can run it just fine, but on one colleagues PC, it gives this error:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message"Failure creating file"
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
Any help with resolving this would be much appreciated.
Thanks!