Numeric Value overflow Error

[gaju_3112]

I have linked One of My access Table with Excel. I am running the upend Access query to insert record from this table(Table that is linked with Excel table) into another access table. Whenever I run this query I get error "Numeric Value Overflow" nsg box. I checked the data types of all fields in excel and Access table and they are compitable. I am not getting any problem in Linked table. Problem occurs only when I run Append query. Plz help me on this. I wasted my 1 whole day on this problem.

 

[boblarson]

If you have NULLS and you are using any calculations in the query, you should use the NZ function so it will substitute a zero, or any other value you specify, if the field is null.

 

[gaju_3112]

No, I am not doing any calculation. I am just copying records from one table (Which is linked to Excel table) into another by running append query.

 

[boblarson]

In that case, you might be trying to insert a value that exceeds the datatype length of the field. So check to see if you might have an Integer in your field and it should be Long Integer, or your text field is set to the default length of 50 and it should really be 100 or 255.

 

[gaju_3112]

I have only text fields in destination table and I already set all of them to 255. This problem is really firstrating me!

 

[boblarson]

Well, I'm down to seeing if you can post the Excel file and the database so we can try it out and see if we can spot the problem. If you go to Tools > Database Utilities > Compact and Repair and then zip the two files together you can post the zip file if it is 393Kb or less.

 

[gaju_3112]

My destination table contains only text fields and all of them are set to 255. I really fade up with this problem.

 

[boblarson]

My destination table contains only text fields and all of them are set to 255. I really fade up with this problem.

Yep, can you post both the database and the excel file? I think we can probably figure this out if we can try them out ourselves.

 

[gaju_3112]

Actually files are confidential and I can not post that. I can explain u situation in more detail_
I want to track monthly transactions in database. I edit one excel sheet in eah month. this sheet is linked with access databse. There is another table in access databse. In that table I apend all the records from linked table. In next month, when records in excel sheet get changed linked access table also get changed and I again run append query for that month. In this way I can track all transaction using linked table as bridge.