Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

OLE 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 an...
Need Help
Show and Tell
  • vanessafvg's avatar
    vanessafvg
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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!

Related content