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