Please be aware that when using data import, if the data being imported has more than 255 characters in a cell after the first 8 rows, the data will be truncated to 255 characters by the Microsoft OLEDB provider which is what is used to import the data. However, this can be addressed by making a change to the Registry on the PC doing the import. Qualify will check these registry values and provide a warning message if they are not set before proceeding with an import.

For xls files, 32 bit –
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel

For xls files, 64 bit –
HKEY_LOCAL_MACHINE\SOFTWARE\wow6432node\microsoft\jet\4.0\engines\excel

For xlsx & xlsm, 32 bit –
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel
(Office 2010 is 14.0, Office 2007 is 12.0)

For xlsx & xlsm, 64 bit –
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel
(Office 2010 is 14.0, Office 2007 is 12.0)

For each of these, the value of TypeGuessRows should be changed from the default of 8 to 0. This can only accept values of 0 – 16, but setting it to 0 means that all spreadsheet rows will be checked (up to the maximum of 16384) for their full length and this full length will be imported.