OLEDB Get Collection - Exception: Invalid value

[Anonymous]

Hi, I'm trying to read an Excel file (.xlsx) with OLEDB - Get Collection Action, but when BP reaches a cell with the value "0.00009", I always get an exception "Internal : Unexpected error Invalid value '9E-05' for a new number". I have tried several formatting ways on the Excel file, but it looks like it makes no difference - every time the same exception. The only way I can read the Collection is when removing this value from the file. Is there any kind of limitation when reading excel files with OLEDB, related to decimals? Do anybody know how I could make it work? Tks, Juliana

[Ravindersaini]

Hi, I'm not sure whether this will help,but try to read the column as string rather than decimal. In your oledb query use this,select str(colname) from tablename. Regards, Ravinder Saini

[Anonymous]

*update select str([colname]) AS [new_col_name] from [Sheet_name$]