Error: Numeric Field Overflow

  • Thread starter Thread starter Emmy
  • Start date Start date
E

Emmy

Hi,

I'm trying to import a text file into access using a
macro. I have saved the import specifications, but keep
getting an error: "Numeric Field Overflow". The table
where the information is appended has number fields that
are Long Integer. Has anyone seen this error message?
Does this have to do with the type of the number fields?

Thanks!!
Emmy
 
What are the values you're trying to insert into the field? Long Integers
are between -2,147,483,648 to 2,147,483,647. If your values are outside of
that range, you're going to have a problem.
 
The numbers have zeros in front of them. Would that have
anything to do with it? I wouldn't know how to get rid of
the zeros because the number could vary and it's fixed
width. Ex) 0000337120 - Needs to import 337120. I've
tried Long Integer and Double and neither worked. Any
suggestions??

Thanks!!
 
Back
Top