Replace NA with Null - Access 2003
 

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.

Replace NA with Null - Access 2003
 

If the database field is formated for a number then "NA" would cause a
mismatch.

If the "NA"s are replacing a formula, you could change the formula so that
is does not return "NA". For example, if the formula "=B1/C1" returns
"#DIV/0!" you could change the formula to =If(iserr(B1/C1),"",B1/C1) to
return a null value instead of an error message.

If the "NA"s are replacing simple data that has been keyed in, you could
replace all "NA"s using the search and replace routine: Edit,Replace,Find
what: "NA:,Replace with: <leave this blank.

tom

"Judi<<" wrote:

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.

Replace NA with Null - Access 2003
 

OH My Goodness!! Now I know I have been at this too long... How did I not
think of that?

I officially need a vacation!

THANK YOU SO MUCH!!

You are my new "hero!"

"TomPl" wrote:

If the database field is formated for a number then "NA" would cause a
mismatch.

If the "NA"s are replacing a formula, you could change the formula so that
is does not return "NA". For example, if the formula "=B1/C1" returns
"#DIV/0!" you could change the formula to =If(iserr(B1/C1),"",B1/C1) to
return a null value instead of an error message.

If the "NA"s are replacing simple data that has been keyed in, you could
replace all "NA"s using the search and replace routine: Edit,Replace,Find
what: "NA:,Replace with: <leave this blank.

tom

"Judi<<" wrote:

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.