[AccessD] Access 97 - Numeric field overflow

Also check the table you're imporing into.  

I've had a corrupt table/Autonumber that went off the charts and gave this error.


----- Original Message ----- 
From: "Heenan, Lambert" <Lambert.Heenan at AIG.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, March 31, 2003 3:33 PM
Subject: RE: [AccessD] Access 97 - Numeric field overflow


> Ok. I think it's time now to see the SQL your using for the append, and
> perhaps a sample of the data that is resulting in the overload error. Have
> you tried importing just one row or data each time? Importing one half of
> the rows and then the other half? i.e. can you pin it down to a real error
> of some sort in the data, like a double that is greater 2^16?
> 
> Lambert
> 
> > -----Original Message-----
> > From: John W. Colby [SMTP:jcolby at colbyconsulting.com]
> > Sent: Monday, March 31, 2003 4:08 PM
> > To: accessd at databaseadvisors.com
> > Subject: RE: [AccessD] Access 97 - Numeric field overflow
> > 
> > Interestingly, I imported the data into A2K and the problem exists there
> > as well.  Truly weird.
> > 
> > In A2K I am at SP3 so I know I am up to date.
> > 
> > John W. Colby
> > Colby Consulting
> > www.ColbyConsulting.com
> > 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Heenan,
> > Lambert
> > Sent: Monday, March 31, 2003 11:13 AM
> > To: 'accessd at databaseadvisors.com'
> > Subject: RE: [AccessD] Access 97 - Numeric field overflow
> > 
> > 
> > Well, whenever I start getting inconsistent behavior such as you describe,
> > I'm, inclined to backup the Db and then decompile it, compact it and
> > repair
> > it. With luck that will sort it out. SP2 is the latest for A97, AFIK.
> > 
> > Lambert
> > 
> > > -----Original Message-----
> > > From: John W. Colby [SMTP:jcolby at colbyconsulting.com]
> > > Sent: Monday, March 31, 2003 11:01 AM
> > > To: AccessD
> > > Subject: [AccessD] Access 97 - Numeric field overflow
> > > 
> > > 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
> > > 
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com