MS Query in Excel
 

I use Query to pull in data from several separate excel spreadsheets at once
for data mining. Recently I've come across a query in which no data is
returned for 2 of 8 columns. The fields (columns) being queried are in
general format on the individual spreadsheets and would normally return
numeric data. But in this case, the two fields return nothing (empty set).
If I add a value criteria to the criteria field then it displays the
criteria in single quotes; like the data is being seen as text or something
similar. The other numeric fields don't have this problem and I can't find
an obvious difference in their formatting. I've tried different formats in
the spreadsheets for the columns prior to querying, but nothing works. I'd
appreciate any insights anyone might have on this one.

Thanks in advance.

MS Query in Excel
 

Might it be a matter of "protection" and/or "permissions" on the problem
columns?

Vaya con Dios,
Chuck, CABGx3



"Terry C." wrote in message
...
I use Query to pull in data from several separate excel spreadsheets at
once
for data mining. Recently I've come across a query in which no data is
returned for 2 of 8 columns. The fields (columns) being queried are in
general format on the individual spreadsheets and would normally return
numeric data. But in this case, the two fields return nothing (empty set).
If I add a value criteria to the criteria field then it displays the
criteria in single quotes; like the data is being seen as text or
something
similar. The other numeric fields don't have this problem and I can't find
an obvious difference in their formatting. I've tried different formats in
the spreadsheets for the columns prior to querying, but nothing works. I'd
appreciate any insights anyone might have on this one.

Thanks in advance.