iserror function in a query

[Sarah at DaVita]

I have a query that brings in data from an excel file and appends it to a
table. Some of the columns have rows that return a #num when I run the query
so it fails. I have tried to use the iserror function to check for this and
replace with a null but it does not work. Formula I am trying to use is LE:
IIf(IsError([ELIE]![LE]),1101,[ELIE]![LE]). The column is formated as a
number and the data currently in the two cells that are causing the error is
1101? and 7xxx but could be anything. Can someone tell my why this is not
working? Thanks.

 

[Pieter Wijnen]

what the column is formatted as has no influence on the allowed data entry
in excel - try using isnumeric() or val() in your query

hth

pieter

 

[Sarah at DaVita]

isnumeric() worked - thank you very much.

what the column is formatted as has no influence on the allowed data entry
in excel - try using isnumeric() or val() in your query

hth

pieter

I have a query that brings in data from an excel file and appends it to a
table. Some of the columns have rows that return a #num when I run the
query
so it fails. I have tried to use the iserror function to check for this
and
replace with a null but it does not work. Formula I am trying to use is
LE:
IIf(IsError([ELIE]![LE]),1101,[ELIE]![LE]). The column is formated as a
number and the data currently in the two cells that are causing the error
is
1101? and 7xxx but could be anything. Can someone tell my why this is not
working? Thanks.