Skip to main content
Solved

Connecting to password protected excel file using firedac drivers

  • May 16, 2025
  • 1 reply
  • 40 views

Forum|alt.badge.img

Can anyone tell me how to ? I can connect to unprotected excel files, but it says “directory not found” when trying to open password protected ones. I have tried to provide password in various property fileds as well as tried to change “authscheme” but no avail. 

Kind regards

Best answer by Ethem Q

Hi ​@WaldekMisiurski,

Unfortunately you will not be able to work with password-protected files as we do not support these with our products. The reason for this is because password-protected Excel sheets involve a different file structure that is proprietary to Microsoft, so it's not something we can possibly accommodate.

Let me know if there's anything else I can help with, I will be happy to do so!

 

This topic has been closed for replies.

1 reply

Ethem Q
Forum|alt.badge.img
  • Employee
  • Answer
  • May 19, 2025

Hi ​@WaldekMisiurski,

Unfortunately you will not be able to work with password-protected files as we do not support these with our products. The reason for this is because password-protected Excel sheets involve a different file structure that is proprietary to Microsoft, so it's not something we can possibly accommodate.

Let me know if there's anything else I can help with, I will be happy to do so!