Numeric field overflow

[SteveE]

I regulary import from excel a large amount of data through a defined macro, this has worked very well until recently but I now keep getting an error stopping the marco completing

"Numeric field overflow" I cannot find any reason for this. if a copy a row of data from excel I can pase it into the table without any problem (I can copy all 1014 rows and pase in ok) but if I try the macro I still get the error.
any suggestions welcome
thanks

Steve

 

[GumbyD]

Check your datatypes. You may have a field with an datatype of integer. If you try to insert a value greater than around 32000 it will fail. Change the datatype to a long integer.

GumbyD

 

[SteveE]

Thanks for your help, I have discovered what was happening. During the import sequence some date fields were blank which is ok as long as they are Null, but they had a space in them this the import was failing because text was trying to import into a date field.