Problem with importing data

[melbert2002]

Hello all,
Im having a problem with importing data from one table to another. Here is the deal. I have a table "TOTAL" This table has about 100 Columns. I have another table called "FULL" with about 200 Columns and a third table "PART" with about 150 Columns. The data from FULL and Part get pushed over to TOTAL (wich is displayed to our customers). TOTAL includes fields from both FULL and PART, ie
FULL:
Column A
Column B
Column C

PART:
Column 1
Column 2
Column 3
Column 4

TOTAL:
Column A
Column B
Column 3
Column 4

Now when I try and insert records into TOTAL from either PART or FULL I get the following error:
Error Converting data type varchar to numeric

I have checked all the columns and noted where decimal is decimal, I even tried to make the defaults Null, but its still not working.

Thanks

mel

 

[Rhys666]

It simply looks like you are attempting to insert character data from one of your source tables into a numeric field in the destination table. Have you tried looking for non numeric values in the fields of your source tables where you're inserting into numeric fields in the destination?

Rhys
The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra
If life were fair, Dan Quayle would be making a living asking 'Do you want fries with that?' John Cleese