Overflow error when appending data to SQL from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I imported an excel spreadsheeting into a local table in Access 2003. There
are ~1400 records (dates, text, and integers). I verified that the date and
integer fields contain only that type of data. When attempting to run an
append query to a sql 2000 database table (with the same destination fields)
I receive an "Overflow" error. I have found reference to "Numeric Overflow"
and am not sure if this is the same. Any ideas on what is causing this and
how to resolve it? Thank you!
 
Figured it out. The short date format in Access "09/26/2006" required 10
characters, the date format in the sql table was 8.
 
Back
Top