Numeric field overflow

M

Mike D.

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.
 
K

Ken Snell [MVP]

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.
 
Top