I've built an append query to add linked data to a table in Access. The link
data has a numeric field and had been predetermined by Access 2003 to be
integer.  I'm encountering numeric overflow when I try to append the data.  
It's very likely that I have numbers over the integer limit.  Is there a way
to convert the data to long?

To temporary overcome the problem, everytime before I press the append
button, I have to make some changes to the data (ie in Append Query, in the
numeric field, add +1-1 and then look at the data).

Thanks,
Carmen