Hi @HassanZaidi,
Please check below.
- Which account that SQL server service is running under? Suggest you using local system account, a admin account or an account that has the read and write permissions on this excel file.
- Please check that whether you have DisallowAdHocAccess registry key under.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.MSSQLSERVER\Providers\Microsoft.ACE.OLEDB.12.0
We then executed below command and key got created automatically.
USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DisallowAdHocAccess', 0
GO
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.