Link Excel Spreadsheet Issue with #Num!

[Guest]

When linking an Excel spreadsheet to an Access Database, some of my number
fields show as #Num!

I have the field formated as a number. Some show correctly and some do not.

Can you offer an explanation as to why this is happening and how I can
correct.

Thanks,

 

[Ken Snell \(MVP\)]

Likely ACCESS (actually Jet) thinks that the "number data type" is smaller
in size than what your spreadsheet actually contains. For example, if the
numbers in the first 25 rows or so are all integers (no decimals), Jet will
set the data type to Integer or Long Integer, then when you have a value
with a decimal part, Jet says it's wrong and displays "#Num!".

You'll need to tell us more about the data to be sure.

One "fix" is to put one of the offending numbers in the first row of the
spreadsheet.