Forum Discussion

Fidzi8's avatar
Fidzi8
Helper V
6 years ago
Solved

DISP_E_TYPEMISMATCH

Hi,  I would need advice. (I know there are enough topics with this problem but I still don´t know :/)   I create excell´s table as master data where i will download data from SAP every day. After...
  • MFelix's avatar
    6 years ago

    Hi Fidzi8 ,

     

    To what I can see this is related with formatting of some data, you can try to take out all the Changed Type steps from your query and check if this is letting you update the information.

     

    On other issues that come accross errors similar to this is to keep the data in the query editor as text so without any change type steps and then on the format option for each column do the correect formatting, this will make the query editor result always the same no format errors, and pass that formatting to the "front end".