how to fill in blanks after an xcel import

[Steve]

I imported data from a spreadsheet into an access table. is there a way to
deal with the empty cells? currently they are empty fields but I dont know
how to interact with them.
This is my first crack at a database and have modified the initial table
alot already in preparing to break it into a bunch of smaller tables. I am
hoping I dont need to modify the spreadsheet, and then reimport.
I would like to run some sort of an update that would fill the blanks of
certain columns with n/a but I dont know what to equate the ?? below too.

UPDATE [table]
SET column = 'n/a/'
WHERE column = ??;

?? is the contents of an empty field

[Steve]

found my own answer,

WHERE column is null
"Steve" <[e-mail]> wrote in message
news:k0*****************@newsread2.news.atl.earthl ink.net...

I imported data from a spreadsheet into an access table. is there a way to
deal with the empty cells? currently they are empty fields but I dont know
how to interact with them.
This is my first crack at a database and have modified the initial table
alot already in preparing to break it into a bunch of smaller tables. I am
hoping I dont need to modify the spreadsheet, and then reimport.
I would like to run some sort of an update that would fill the blanks of
certain columns with n/a but I dont know what to equate the ?? below too.

UPDATE [table]
SET column = 'n/a/'
WHERE column = ??;

?? is the contents of an empty field