Insert into table from another table excluding a column
I have a table t1 (id int(5), recordnum varchar(10),claimnum float) and 
table t2( id int(5), recordnum varchar(10), Docnum varchar(max).

i am inserting the t2 data into t1 as below

insert into t1(id, recordnum, claimnum) 
select id,recordnum,Docnum

this statement executes perfectly till i have all numbers in Docnum.
My issue is i have few columns like Docnum= '0067576A887' which are not inserting and throwing me a issue.

Is there any way i can exclude this column and continue inserting the other columns
Insert into table from another table excluding a column
===

I have a table t1 (id int(5), recordnum varchar(10),claimnum float) and 
table t2( id int(5), recordnum varchar(10), Docnum varchar(max).

i am inserting the t2 data into t1 as below

insert into t1(id, recordnum, claimnum) 
select id,recordnum,Docnum

this statement executes perfectly till i have all numbers in Docnum.
My issue is i have few columns like Docnum= '0067576A887' which are not inserting and throwing me a issue.

Is there any way i can exclude this column and continue inserting the other columns