Numeric field overflow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have a Form where I have a combo box in the header. The user will
enter data in this box and the data will display in the form body.

My problem is that for some of the records, I receive the following error:
"Run Time error 3349 - numeric field overflow"

Note that this is a text field in a table that is actually a linked Excel
spreadsheet. If I import the data, this problem goes away, but I really want
to have it linked ...

I am not sure what the problem is ... can anyone give insight?

Thanks,
Mike.
 
Chances are that Jet linked the spreadsheet and "identified" that EXCEL
column as Integer, and you have some numbers that are larger than can be
stored in an Integer field (greater than 32767), so that creates an error.
 

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 3
Numeric field Overflow 1
Numeric Overflow Error 4
Numeric Field Overflow 2
Numeric field overflow 1
Numeric field overflow 1
Numeric Field Overflow Error 5
Overflow error when appending data to SQL from Access 1

Back
Top