Formatting data imported into a query

[accessaspire219]

Hi,
I have a query which imports data from a linked table. One of the columns I import is alpha numeric, when access imports it, it sets the format depending on what the first row is to either "number" of "text". However because of this it does not see any records which are in the other format (other than what it set)
I wanted to know if there is a way to work around this issue since I really need to see all the records.
Any help is appreciated.
Thanks.

 

[boblarson]

Don't do a "make table" each time but instead clear your table and do an append. Then the data types are already set.