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