Skip to main content

Hello,

I am trying to connect to excel sheet using excel as a DB operation. The excel file is password protected. is there a way to connect as a Db to password protected excel sheet? I have the password with me.

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";
 


Reply