Forum Discussion
How to Append Tables OLE DB or ODBC error
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
2 Replies
NaveenGandhiMemorable Member
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!!!