Convert to Excel Query

[Johnny42]

I can import external data with a query.
However I cannot figur out if it is possible to query numeric values only ..
can this be done in an excel query ?
I tried to build in Access...works...however cannot reproduce in excel

 

[SkipVought]

Johnny,

What works in Access that does not work in MS Query?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Johnny42]

Well....how would I select numeric values only with a query from excel?

 

[SkipVought]

I tried to build in Access...works...however cannot reproduce in excel

How did you build it in Access that cannot be done in Excel?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Johnny42]

I built this and got the resulting sql :
SELECT ICITEM.DESC, ICITEM.ITEMNO
FROM ICITEM
WHERE (((IsNumeric([ICITEM]![ITEMNO]))=True));


How can I interpret this in an excel query ?
or how can I buil this from the excel query wizard and get only numeric values ?

 

[SkipVought]

Edit you query -- Data/Get External Data/Edit Query --

Hit the SQL Icon.

Insert the IsNumeric function in the Where clause

File/Return results to Excel



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244