Issue 3329: ODBC Import from Excel ignores subsequent column values when the first 8 data rows contain blank (NULL) values for a column

This problem is caused by the Microsoft Excel ODBC driver which will, by default, scan the first 8 rows of your data to determine the type of data in each column.

If the first 8 rows all contain blank (NULL) values in a column, the ODBC driver assumes the entire column is empty.

A warning is displayed when an Excel spreadsheet is being imported AND the first 8 data rows in any column are blank.

There are two possible workarounds to the problem:

• Insert dummy values (e.g. 0) in the offending columns
• Export the sheet as a CSV file from Excel, then import the CSV file