Share via

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

Anonymous
2012-03-23T11:49:43+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-03-26T20:08:48+00:00

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.

Was this answer helpful?

3 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-03-23T14:39:40+00:00

    MS Query will try to determine the data type of the source data. If a column has a mix of text and numeric data, MS Query will pick one and ignore the other. For example, if you have these values

    10

    100

    23

    Alpha

    50

    MS Query will likely return this:

    10

    100

    23

    (blank)

    50

    Is that your situation?

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-03-26T18:55:27+00:00

    This is my situation! What is solution for no blank in this example?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments