Append Query in Access

  • Thread starter Thread starter Lakshmana
  • Start date Start date
L

Lakshmana

While I am Appending a Table with Append Query Some times
It is giving me an error "Numeric field Overflow" and
terminating from the query withour appending. After making
the Query, for the first very few instances it is working
and for further instances it is giving me the error. Again
after redoing the query it is working for the first time
and later it is not. Can any body help me in this regard.
To over come this error.
\Thank You
 
Lakshmana,

One possibility is that one (or more) of the numeric fields in your table is
of the Integer Type, which can contain only values in the range: -32,768 to
32,767 . If any of the numbers you are attempting to import are outside
of that range, your query will fail.
 
Back
Top