Automate Export Data from Excel to SQL

[nimaaax]

I am trying to export (and automate) a VBA excel file to SQL . So I tried to configure an Excel data source as a linked server

But I got the following issue:



Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The OLE DB provider "Microsoft.ACE.OLEDB.16.0" for linked server "EXCELTOSQL" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "Microsoft.ACE.OLEDB.16.0" for linked server "EXCELTOSQL". (Microsoft SQL Server, Error: 7399)


Thanks!

 

[nimaaax]

and I have full access to the Server