Bulk Insert Activity Error

I am Trying to Bulk Insert some records into SQL through Excel. I am getting the following Error

image

Snapshot of Database :

image

Snapshot of Excel :

image

Any help would be appreciated

Hi @Ishan_Shelke1

Check whether all the columns datatype matches?

Regards
Sudharsan

Hi @Ishan_Shelke1

Please make sure you have the same “Column Names” and the same “Data Type” in excel and SQL, please make the changes accordingly and try insert.

Thanks.

How do I check the Data type in Excel ?

How do I check if my Excel column data type matches with my excel one ?

Try with these query
select data_type from Tablename.columns

Regards
Sudharsan

and compare whether do you have same datatype in excel too, And in excel you know right where to check for cell formatting?