How to Append Tables OLE DB or ODBC error

[Anonymous]

Hi, I need some help with appending 3 tables together. I am getting this OLE DB or ODBC error when I apply the query.

I have 3 tables : table1, table2, table3

Originally I appended table1 and table2 together without issue. However, once I tried to also append table3, it started getting this error. 

I have ensured all the data types are the same by going to 'transform data' and copying the 'changed type' from table1 to table3 (I did the same step when I appended table1 and table2).

What is causing the error and how do I fix it? All three tables have the same columns and in excel, the format of it all looks the same 

[NaveenGandhi]

Hi @Anonymous 

Check if the below solution works.

https://community.fabric.microsoft.com/t5/Power-Query/OLE-DB-or-ODBC-error-type-mismatch-exception-from-HRESULT/td-p/43582

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[Anonymous]

Hi Naveen, thanks, ill check over the data. Do you have any other suggestion?