I have a spreadsheet I am trying to import into Access 2003 and I keep coming
across type mismatches. I have noticed that the previous user would place NA
into a field if the information was not needed rather than just leaving it
blank.

When this comes to a field that is supposed to be a number, could this be
causing my mismatch? If so, how can I replace those "NA"s with a Null value?
Is there a way to do it accross the board all at one time? (Even if this is
not the primary cause I would like to know how to do this anyway.)

Thank you again for your help, I am deeply appreciative.