View Single Post
  #1  
Old April 27th, 2004, 04:39 PM
Dkline
external usenet poster
 
Posts: n/a
Default #Num! in linked Excel file

I have a linked Excel file. Within that file is a field/column of numbers.

When I look at it in Excel - I see the numbers.

When I look at in Access - I see #Num! When I see it in the Form, I don't -
the field is blank.

What is the #Num! telling me - that it is not a number? If it's a number in
Excel, why wouldn't Access see it as a number.

The numbers are not overly large. Range is 1,000,000 to 100,000,000.