Strange Doings With Blank Data Imported From Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

quirkyjoe - 14 Mar 2007 22:18 GMT

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!

Reply to this Message

Damian S - 14 Mar 2007 23:50 GMT

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.

> 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
[quoted text clipped - 11 lines]
>
> Thanks!

Reply to this Message