How does MS Query assign data types?

  • Thread starter Thread starter Tim Green
  • Start date Start date
T

Tim Green

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,
 
I'm not 100%, but i recall once when i did this, that MSQuery assigned the
type based off whatever value was in the first record of the field.

Unfortunately, this seems rather odd and i don't recall finding a solution
other than having the first record as dummy textual data
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO with mixed data 2
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Variable Data Type 4
MS Query Results 1
MS Query problem 2
MS Query Cell Limit 2
Excel Query fails to include data? 1
A data validation question 1

Back
Top