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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overflow error when appending data to SQL from Access 1
Numeric Field Overflow Error 5
Numeric field overflow 1
Numeric Field Overflow 2
Import problem into SQL Server 2005 linked table 1
Numeric field Overflow 1
Numeric Overflow Error 4
Numeric field overflow 1

Back
Top