View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Green Tim Green is offline
external usenet poster
 
Posts: 17
Default How does MS Query assign data types?

Hi,

I am running a query on a closed workbook, and one of the fields contains
alphanumeric data, but most of the values are numeric only. As a result,
Query is ascribing a number data type and returning Null for any values
containing letters.

Is there an easy way to force Query to treat a field as containing text
values?

Thanks,