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