Overflow error when appending data to SQL from Access

[spburke]

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!

 

[spburke]

Figured it out. The short date format in Access "09/26/2006" required 10
characters, the date format in the sql table was 8.