Hello,
I used this example to import data from Excel to SQL Server
https://www.aspsnippets.com/Articles/How-to-import-data-from-Excel-to-SQL-Server-2008-using-ASPNet.aspx
but I get the following error:
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" does not contain the table "Sheet1$". The table either does not exist or the current user does not have permissions on that table.
I tried all the solutions given in the article plus when I execute the stored procedure on the SQL Server, the command is succesfully executed and the data are imported.
Any ideas what might be going wrong?
Thank you in advance.