Database Query -- Data Type Mismatch
 

I am using MS Query in Excel 2000 and 2002 to do a database query of a named
range on another Excel file. The challenge I am having is that the query
treats columns/fields that have a lot of numeric values as number data type
fields and ignores (leaves as blank) any text or alphanumeric entries in
those
fields. Is there a way to change the query or criteria so that it treats
certain fields as text even if they have a lot of numbers or all numbers in
them? I have formatted the original Excel fields with a text cell format,
but this does not help.

Ultimately the query will be added to a sheet using VBA, but I can't get the
query to work right itself.
Thanks.