https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88414#M38961 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 Wed, 30 Aug 2017 00:17:00 GMT Ravindersaini 2017-08-30T00:17:00Z https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88413#M38960 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 Tue, 29 Aug 2017 20:40:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88413#M38960 Anonymous 2017-08-29T20:40:00Z https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88414#M38961 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 Wed, 30 Aug 2017 00:17:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88414#M38961 Ravindersaini 2017-08-30T00:17:00Z https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88415#M38962 *update select str([colname]) AS [new_col_name] from [Sheet_name$] Wed, 04 Oct 2017 15:51:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB-Get-Collection-Exception-Invalid-value/m-p/88415#M38962 Anonymous 2017-10-04T15:51:00Z