Numeric field overflow

C

Crazyhorse

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
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

*@!? Numeric Field Overflow 2
Adding data to MS Access from csv file 0
Linking table gets numeric field overflow 2
Numeric Field Overflow Error 5
Refreshing Data Daily From a Linked Excel Spreadsheet 2
showing #Name? in form field 1
Incorrect error msg: Null value in an auto-number field 0
Embed the same Excel multiple times 0

Top