Tag Archives: Excel

Connecting to a password-protected Microsoft Excel spreadsheet using Delphi TADOConnection

There is a little trick to connecting to a password protected .xls Excel spreadsheet using the Jet 4.0 OLEDB driver.   If one uses the obvious Password=xxx;User Id=Admin you will get an error “Workgroup Information file missing or file is … Continue reading

Posted in Delphi | Tagged , , | Leave a comment