Bulk insert: The provided columns in the DataTable do not match the column data types in the database

Help Activities
, ,
1

I am trying to add acme data into database, but i couldn’t showing below error

The provided columns in the DataTable do not match the column data types in the database.

image

Thanks in Advance

2

@ManjunathReddy your WIID will be in String and in database it is Int. Change it to String in database or change it in data table to Int

3

you can find sample values below

image
image743×259 4.73 KB

4

@ManjunathReddy how you are extracting data from ACME. Its Extracting be default as a string.

5

image

6

@ManjunathReddy Yes. Its getting WIID in String by default. You need to change WIID type in database.

7

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