I am performing an excel query from another excel workbook. In each case
there are two columns where there is not alot of data present in the source
data base. In those two columns there are both number and text data. I
format those two columns to either general, number or text format and data
still goes missing. (eg. When I put both columns to text format, the data
which is made up of numerical characters does not get transfered in the
query, whereas, data containing text characters is transferred.

There are some instances where I put some bogus data in the first several
rows as many cells are empty. Sometimes this causes all data to be captured.
This is still not a good as the bogus data has to be added and removed.

Is there a better way to get all the data to be captured in the query.