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.
Userlevel 6
+15
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.