If you try, you receive the following error message: 'Could not decrypt file.'Ī workaround for the 'could not decrypt file' problem Excel 97 Excel 2000 Excel 2002 Excel 2003. If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection string.

Use IMEX=0 instead to be sure to force the registry TypeGuessRows=0 (scan all rows) to work. Please also note that adding the IMEX=1 option might cause the IMEX feature to set in after just 8 rows. That's the key to not letting Excel use only the first 8 rows to guess the columns data type. 'SELECT * FROM ', start picking the data as of row 5 and up to column D.Ĭheck out the located registry REG_DWORD 'TypeGuessRows'.

If you want to use an Excel template (e.g., a budget planner template), scroll down until you find the template you want to use and then click it once to open its window. excel worksheet name followed by a '$' and wrapped in '' brackets. Click or double-click the Excel app icon, which resembles a white 'X' on a dark-green background. Note that this option might affect excel sheet write access negative. 'IMEX=1 ' tells the driver to always read 'intermixed' (numbers, dates, strings etc) data columns as text. 'HDR=Yes ' indicates that the first row contains columnnames, not data.

Excel spreadsheet