Data type mismatch while importing data into excel using microsoft query

Question

Hello sir,

I am Vivek, and my query is regarding Data type mismatch while importing data into excel using Microsoft query.

Here is the detailed explanation of my query :

I am importing data form one excel file (Named: MPI Summary.xlsx) to another excel file (Named: Master File_Malwa.xlsm) using Microsoft query.

Snap of MPI Summary (1):

Snap of MPI Summary (2):

Snap of Master File_Malwa

Now we can see difference in HeatNo Column of both workbook.

As highlighted in 1st & 2nd snap, in MPI Summary workbook there are records with numerical & alphanumerical value in HeatNo column.

But in Master File_Malwa workbook, in HeatNo column, only numerical valueis imported. Actually, it should import values for all records (numerical & alphanumerical both) in HeatNo column.

Please help to solve this query.

Thanks & Regards

Vivek

Answer 1

Hi Vivek,

To resolve your concern about Excel, try the steps from this link.

let us know how it goes.