Numeric field overflow

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Crazyhorse - 29 Jan 2007 23:29 GMT

What does this mean exactly?

I have a spreadsheet linked into access. Then I take one column from the
linked spreadsheet and then make an append query. The data type is the same.
Number from the excel sheet and then appended to a number field into a table.
It works once and then when you try to append again I get this “NUMERIC FIELD
OVERFLOW” message. If I import the excel spreadsheet and not have it linked
it works fine. WHY.

Thanks in advance

Reply to this Message

Jerry Whittle - 30 Jan 2007 16:37 GMT

What kind of number field in Access? A Byte is only good from 0-255. Integer
between 32,768 and 32,767. A Single is also somewhat small. Try setting the
data type to Long Integer or Double if you need decimals.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> What does this mean exactly?
>
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message