Help on excel worksheet linked to access table and form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have an excel worksheet which was exported to access as
a linked table and then to a form. Now in excel i have a
column with formula that returns "" (blank). This shows up
as #Num in access table and form. is there a way i can get
blank in access form and table as well.

thanks
 
It would appear that the Access field that is showing the
NUM# is of a numeric type, and by putting " " into the
relevant Excel field, Access sees this as text, and hence
gets confused. A workaround would be to change the Excel
Formula that is creating the " " to put a zero in the cell
instead.

Hope this helps

Paul Falla
 
Back
Top