Make table query will work in datasheet view but will not make tab
 

I am using a make table query to gather some information from a table linked
to excel. The query will work fine in design and datasheet view. However
when I try to run the make table function, I get a "Numberic Filed Overflow"
error. How can this query work in datasheet view but not be able to execute
the make table function? Any suggestions?