How to upload the downloaded input excel data to MSSql database

[Pavanraj_Shetty]

Hi @Vrishchik

Try this

BulkInsert Fails With Column Data Type Mismatch

Resolution for the operation Bulk insert: The provided columns in the DataTable do not match the column data types in the database. Issue Description: The Bulk Insert activity is used in the context of an Oracle database connection. The Oracle Manage Access driver is used to connect to the Oracle database. [image] Error message: The provided columns in the DataTable do not match the column data types in the database. [image] Root Cause: This is because the Oracle database kept Integer…

Hope this might help you