iserror function in a query

  • Thread starter Thread starter Sarah at DaVita
  • Start date Start date
S

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.
 
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
 
isnumeric() worked - thank you very much.

Pieter Wijnen said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top