Normal insert query is working but bulk insert is not working in sql

Help Something Else
1

When we use insert in Sql it is working but bulk insert query is not working due to The provided columns in the DataTable do not match the column data types in the database

2

@sathish_Kumar6

You have to make sure the dataype of each column should exactly match with sql data columns

Better use a build datatable with columntypes as need and first test with adding a single row…then replicate it for more

Cheers

3

ok ill go with one row using build data table and ill let you know but do you have any idea why its working in normal insert query but is not working in bulk?

4

Thanks @Anil_G it is worked

like i have built the data table for it then changed the date type variable as date time then it is worked… thank u so much for the idea

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.