Data type errors while using Excel to Record List widget

Data type errors while using Excel to Record List widget

  
Importing Excel sheets can, sometimes, be a "tricky" thing since Excel has a tendency to hide a lot of information for each cell and, sometimes, reading it back is troublesome.

Hence, one good way to be sure all data is really in the needed format is using a clean, "homogeneous" method to fill the Excel with data. For instance: save the Excel sheet in .csv format and import it back into an Excel (.xls) file sheet. That normally garantees success where everything else fails.

How to:

1. Save as .csv the Excel sheet
2. Open a new Excel file (or remove all data from the original sheet - all cells in it, to make sure)
3. Data > Import External Data > Import Data menu option selecting the right .csv file with options:
. semicolon separator,
. text qualifier: none,
. choose appropriate date types for all columns
... btw, credits for this workaround should entirely go to Marco Cunha :)

Thanks Marco