Excel as a DB not working for password protected sheet

Hi @Akshay.M2 ,

You can achieve that using the below connection string and mentioned password in the end.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=YourExcelFile.xlsx;Extended Properties="Excel 12.0;HDR=YES;IMEX=1;Password=your_password";