Question

Excel as a DB not working for password protected sheet

  • 22 May 2024
  • 1 reply
  • 35 views

Badge +2

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.


1 reply

Userlevel 6
Badge +15

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