Numeric field overflow

[dimpie]

Hi - My automation database imports a lot of reports from excel. I have been
running this database for quite sometime now and all these days it has been
working fine. I split the databse and now i get this error

"Numeric field overflow"

This is the statement i get the error in:
DoCmd.TransferSpreadsheet acImport, , "tbl_IBACCT_Temp", PathStr &
"IBA_CCT_WF.xls", 0

Please advice for what i am doing wrong here. As always your help is
apprecited.

Thanks,

 

[Maurice]

My guess is that you are trying to import more records than is possible
stated in your datatype. Set the numerical value to long integer (You have to
check which field is causing the overflow). See the Access help for the
specific datatype sizes.

hth

 

[dimpie]

It give me this error only when i use the split database. I checked all the
numeric fields and they are all declared as long integer. Please advice
Thanks

 

[Maurice]

Then normally you shouldn't have a problem. Is the table you use already in
use or has it been used before? Maybe the autonumber has reached the number
where the amount of records is causing the numerical overflow.

Try importing it into a clean new table for testing purposes and see if you
get the same message. This way you can eliminate the fact that the datatype
is incorrect because long integer should get you up to 2 million.

 

[Pete]

Check any field that starts with numbers, even if it includes text. Access
has a habit of making the field numeric if some type of the first part has
numbers and then the text in it crashes your import. Set up the import
template first and save it to reuse. If I'm going to do it once I see if
any fields have numbers first and then insert a letter as first charcter,
like A. Then it is easy using the left() function to strip the charcter
after and change the field as needed in the table later. If your going to
do the import more than once, take the time to create an import template
with the correct field definitions.