"Numeric Field Overflow" message

[PaulA]

I am importing data from multiple Excel spreadsheets through a coded automated procedure.

Initial testing was successful, but not I am getting a "Numeric Field Overflow" message. I checked the Knowledge Base and the only article talked about dates earlier than 1900. I checked the files for date error and none are present.

What would be causing the error?

Thanks.

Paul

 

[Drevlin]

It sounds like your importing Numbers that are too large for the fields.
i.e. Your field size is set as a Long but your numbers are larger then 2,147,483,648.

 

[PaulA]

Doesn't seem to be the problem--

T hanks for the imput--

The values being imported are quite small both in actual value and in number of characters. This doesn't seem to be the problem.

Would formating of numbers at the Excel end make a difference? There may be some with "general" and some with "number" formatting. Would Access have a problem with this?

Thanks.

 

[Drevlin]

That might be the problem. If Excel is reading the numbers as characters it could be causing a problem.