Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does MS Query assign data types?
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 "Tim Green" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Assign Web Query Result to a Variable | Excel Programming | |||
Assign a single variable to an Array filled with same data types | Excel Programming | |||
How can I assign delimiters to an excel web query? | Excel Discussion (Misc queries) | |||
How can I assign delimiters to an excel web query? | Excel Discussion (Misc queries) |