Forum Discussion

adrien5555's avatar
adrien5555
Helper II
10 years ago
Solved

OLE DB or ODBC error DISP_E_TYPEMISMATCH

Hi All,   this error shows up when I try to refresh data.   The data source is a local csv :     Config: windows 10   thanks for helping :) Adrien  
Need Help
  • austinsense's avatar
    austinsense
    10 years ago

    The type mismatch is probably happening because you're doing some conversion from the orginial data types - go into the query editor and remove any type conversions and see if that works.

moralescas's avatar
moralescas
Frequent Visitor
7 years ago

Just in case someone experiences this problem still.

Although I had not made any changes to my columns, it simply had a conflict with the name of the columns.

 

I had used the letters "i" and "I" (in capitals) to name two of my columns.  

I changed the names of the columns, closed and applied, and it worked again. 

 

Paulo