microsoft query from excel file returns empty cells while source file has data in the cells

I'm using MS Query to upload data from Excel file to another excel file. When query is executed, some data is not uploaded and looks like empty cell while the original file shows the data being in the cells.
 

Question Info


Last updated August 13, 2019 Views 2,018 Applies to:
Answer
Answer

Keep in mind that when you are using MSQUERY, you are bound by database rules...not Excel rules.   Consequently, you would need to ensure that ALL of the values in your source column are TEXT.

 

Regards,

Ron Coderre
Microsoft MVP - Excel

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.