[AccessD] Access 97 - Numeric field overflow

John W. Colby jcolby at ColbyConsulting.com
Mon Mar 31 10:00:35 CST 2003


Guys,

It's been awhile since I have dealt with A97.  I am doing an import of data
from excel spreadsheets.  The data in the spreadsheet is a dbl datatype, but
is really a long int, i.e. no decimal points.  I am linking the spreadsheet,
whereupon I see that the datatype of the field is dbl.  I build a base query
that runs these fields through a clng() to convert them to long integers.  I
then append the data into a table.  The append process works the first time
it is run, then the second time, I get a Numeric Overflow.  I get the
overflow between the "you are about to..." warning and the "X records did
not append..." error.  In fact that second error never occurs.  Once the
error occurs, I have to shut down the db and re-open it, whereupon the query
will run successfully one time, then the error again.

I am at SP2 for A97, and I don't remember what the latest SP is for A97.

Has anyone ever seen this problem?

John W. Colby
Colby Consulting
www.ColbyConsulting.com

----------------------------------------------------
Is email taking over your day?  Manage your time with eMailBoss.
Try it free!  http://www.eMailBoss.com




More information about the AccessD mailing list