"Numeric Field Overflow"

[lars7]

Hi,
I'm getting a "Numeric Field Overflow" when I'm trying to import an excel file to a table, does anyone know what this is and how to fix this.

 

[mp9]

Say you have a field defined as a Byte - this can only take whole numbers up to 255. If you try to import a bigger number, you'll get this sort of error.

Other numeric types have their own limits. Also, trying to import a decimal into an integer field may cause problems.

Your best bet is to experiment with changing the numeric data type of some of your fields.

 

[JerryKlmns]

Trying to import a Double data type value into a byte field?

Check the values at your excel file. You could Copy + Paste Append records for columns A-F. If it works that means data types in your table accept the values from the excel for those columns. Delete all records from your table. Copy + Paste Append more columns. Repeat till it works.

 

[lars7]

Hi there,
Thanks for responding,
I have tried all you said and I still have the problem. I can copy and paste fine into the table and if I import the file into the database manually I only only get some errors in a date field that has blank cells. The 3 fields that are Number fields are actually currency fields but when I imported the first file it made them numbers and I left them that way. I have tried changing them to currency but I got the same result.

 

[lars7]

Hi again,
I have discovered it's something to do with the table being linked. I have 2 other files I import into linked table and have had no problems with them.

 

[lars7]

Hi,
I have got around the problem by Importing the file into my frontend and then running an append query to the table in the backend. I'm sure there was an easier way to do this but I have discoverd now that you can append to a table in another database so "every cloud has a silver linning