Doing an Excel to Excel query, that is simple enough that the wizard is
adequate. One of the source fields (Price) contains both numeric data, and
when such data is not avaiable, a "-". No filters are applied to the price
field.
In the wizard, preview lists only one item, the "-" unlike the other fields
that preview as a complete list. The query correctly returns all the field
values except price, which except for the colum label, is all blank.
Shouldn't query return the price value even if it is text?
Thanks for any suggestions.