| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to replace null values with zero? | Setting up and Configuration of Excel | |||
| Replace Null Values in a Column | Excel Discussion (Misc queries) | |||
| replace null cells within a range to 0 | Excel Discussion (Misc queries) | |||
| Replace Null value in Coloumn | Excel Discussion (Misc queries) | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
