Excel Query not returning numeric values

[Tammy Baker]

Iam having problems with data in a column that has both
alpha and numeric data. The query is pulling in the
alpha values but not the numeric values. The field for
the record is blank if the value is numeric???? Any
ideas????

I accidently poasted this to the wrong newsgroup the
first time. Is there any way to delete the other entry?

 

[Ken Wright]

What is the query - Give us some more details and an example of the data.

No you cannot delete the other note - forget it unless you want to post another to it saying that
you have taken the problem to the correct group, which might save someone some time trying to
understand it for nothing.

 

[Tammy Baker]

I created a query to bring info from an excel spreadsheet
to a template. One of the fields thta is brought in is a
field listing color codes. Some of the codes are alpha
and some are numeric
Examples:
RED
NVY
010
325
659

All of the codes that are alpha are being pulled into the
template but the codes that are numeric are not???
The query is pulling in dates and other values fine.

Thank you for your time!

-----Original Message-----
What is the query - Give us some more details and an example of the data.

No you cannot delete the other note - forget it unless

you want to post another to it saying that

you have taken the problem to the correct group, which

might save someone some time trying to