[AccessD] Access 97 - Numeric field overflow

Hi John

Sounds strange. Try to replace CLng() with Int().

Or, if you like, you may send me a sample sheet and your table and
query and I can run it here ...

/gustav


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