Tag Archives: Excel

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

Posted on March 11, 2012 by admin

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