specify data type in MS Query?
 

I've got a query that pulls a field that has some text stuff, some blank
spaces, and some zeroes. I want it to treat that field as text, but it seems
to sometimes treat as text, sometimes treat as number.

I've got a dummy first line with a big ol' X in there, it STILL sometimes
treats it as a number. Suggestions?

Excel 2003, SP3