Numeric field overflow

G

Guest

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
 
G

Guest

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

Linking table gets numeric field overflow 2
*@!? Numeric Field Overflow 2
Refreshing Data Daily From a Linked Excel Spreadsheet 2
Numeric Field Overflow Error 5
Numeric Field Overflow - Linked .txt File 1
Append data to linked SQL Server 2008 table 0
Numeric Field Overflow 8
Access import from Excel - Append & Update simultaneously 1

Top