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