Numeric field overflow. (Error 3349)

[Computethis]

I get this error message while we are trying to import a "text" comma delimited file.. We have been importing this file for over two years with a simple macro and now all of the sudden it is giving me trouble...

Can anyone help.

The text file is simple a material list

4567r,TR12299,1

that is it...

Thanks!

 

[lameid]

Try creating a new import spec and import every field as text. If it imports, run a query using isnumeric on the fields that were numbers to discover what records are giving you trouble. If it still fails, try breaking the file into two smaller files.

 

[Databaseguy]

Check your spreadsheet and look for #na, #Val, #ref etc. Also, make sure there's no divide by zero cells on the spreadsheet. One last thing, make sure all of the data in all columns is of a like type. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Computethis]

With both of your help - I solved it

Thanks!