Home > Documentation > MS Excel to MySQL > FAQ

I have mixed data in MS Excel spreadsheet: most rows contain numbers, but few of them contain strings that are converters into NULLs by Excel-to-MySQL. How to fix it?

MS Excel data access driver reads a certain number of rows (by default, 8 rows) from the specified spreadsheet to recognize the data type of each column. That is why mixed data from particular column may be interpreted as numeric although contains few text values. In this situation all text values will be extracted as NULL.

To fix it, set the value of the TypeGuessRows registry key to zero (0) so that MS Excel data access driver scans the entire worksheet instead of first 8 rows as by default to find the appropriate data types. Here are the full paths of registry keys to modify:

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel\TypeGuessRows

If there is no "Office\14.0" subkey, try to locate "Office\12.0" or "Office\15.0" for other versions of MS Excel.

Have more questions? Contact us