Expressing a "Null" value in Excel
Posted on 2008-06-16
I have an Access file that has several links to Excel worksheets. Several of the worksheets have formulas that mix numeric and text values, such as the following: '=IF(A5,5,"Alpha")'. Excel handles mixed values with virtuosity, but when linked, Access will interpret the field as either Text or Numeric; and if the value is numeric, it will return an error for text values, and vice versa. If I were to change the formula to '=IF(A5,5,'')', I still get an error, because a blank string is not the equivalent of a null value. Excel, apparently does not have the equivalent of a null value, as '=IF(A5,5,Null)' produces a '#Name' error. What can I do to eliminate the errors I'm finding in Access?