Strange Doings With Blank Data Imported From Excel

  • Thread starter Thread starter quirkyjoe
  • Start date Start date
Q

quirkyjoe

I imported some data from Excel and one field should either have a
value of "AB" or the cell was missing on import - that is, nothing was
in some of the Excel cells for that particular field - at least
nothing that i could see.

I use a query in ACCESS and say if "<> AB" then set a created field to
"True".

Turns out that some values are blank in Excel but ACCESS is setting
the created field to "False".

What might be causing this goofy problem and how do you suggest I
handle it?

Thanks!
 
Hi quirkyjoe,

You will need to handle the value being NULL, so have something like
if isnull(FIELD) or (FIELD <> "AB") then true else false

Hope that helps.

Damian.
 
Back
Top