Forum Discussion
Post ProdigyOLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
Hello
I am getting the error "OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))." when trying to refresh my data.
I have duplicated one column and converted it to the whole number. But in some rows, their alphanumeric character which I think is giving an error. Can you pls help me with how I can resolve this?
then you must first find them and convert them to ablank or null before you can change it to a whole number? Or you can just create a a new column that checks if its a number and then puts the number in the new custom colume ie
if Value.Is(Value.FromText([COLUMN]), type number) then COLUMN else null
5 Replies
- vanessafvg
Community Champion
are you saying you have changed the field to a whole number but there are still some alphanumeric characters in it? if so that would explain it. You could remove the error rows. But what is the rule you need to apply here? What happens to those values if you only looking for whole numbers?
gauravnarchal- vanessafvg
then you must first find them and convert them to ablank or null before you can change it to a whole number? Or you can just create a a new column that checks if its a number and then puts the number in the new custom colume ie
if Value.Is(Value.FromText([COLUMN]), type number) then COLUMN else null
hi gauravnarchal ,
If the Column contains both Alpha-numeric, Numeric, Text values, you will not be able to assign the data type = whole number for that column. Here are two steps that you might wanna take now
1. Either filter all the Alpha Numeric values from the column.
Convert Datatype to Whole Number
After conversion remove errors. (right click on Column1)
2. Select the row Data type as "Text"
Thanks!
