Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Query
I have an Excel database that I'm querying. One of my fields has code
information: some are just numeric (88523) and some are alphanumeric (P5036). When I get the results of my query, the alphanumeric fields are left blank. The rest of the record is intact. I've tried various combinations of formatting the fields and have not been able to get around this. Does anyone have a solution? Thanks -- Suz |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Query
I believe MS Query looks at the first records to determine the field type. If
they are numeric, it sets the field as numeric and sets all text values to null. Alternatively, if Excel decides that the field contains text, numeric values will be set to null. Try this: Set the alphanumeric column format to TEXT, then use one of the various methods to insure that all of the values become text. (eg <data<text-to-columns....set the field to text., etc Does that help? *********** Regards, Ron XL2002, WinXP "Suzseb" wrote: I have an Excel database that I'm querying. One of my fields has code information: some are just numeric (88523) and some are alphanumeric (P5036). When I get the results of my query, the alphanumeric fields are left blank. The rest of the record is intact. I've tried various combinations of formatting the fields and have not been able to get around this. Does anyone have a solution? Thanks -- Suz |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Query
That worked, thanks!
I'll have to remember the data-text to columns commands. -- Suz "Ron Coderre" wrote: I believe MS Query looks at the first records to determine the field type. If they are numeric, it sets the field as numeric and sets all text values to null. Alternatively, if Excel decides that the field contains text, numeric values will be set to null. Try this: Set the alphanumeric column format to TEXT, then use one of the various methods to insure that all of the values become text. (eg <data<text-to-columns....set the field to text., etc Does that help? *********** Regards, Ron XL2002, WinXP "Suzseb" wrote: I have an Excel database that I'm querying. One of my fields has code information: some are just numeric (88523) and some are alphanumeric (P5036). When I get the results of my query, the alphanumeric fields are left blank. The rest of the record is intact. I've tried various combinations of formatting the fields and have not been able to get around this. Does anyone have a solution? Thanks -- Suz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions | |||
enable automatic refresh | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) |