Import Data into table from excel file using c#.

  • Thread starter Thread starter Akhterhussain
  • Start date Start date
A

Akhterhussain

Guest
when i am import data into table from excel sheet ...it giving error of Cannot insert explicit value for identity column in table 'OrderDetail' when IDENTITY_INSERT is set to OFF.

I did n't define my first column Name in my excel sheet ,because it number auto generating ,so how can i managed it before importing data into db table

Continue reading...
 

Similar threads

M
Output SQL Table to existing Excel file in SSIS / C#
Replies
0
Views
90
MChalut
M
G
How do find min value based on parameter from excel range column by column using C#
Replies
0
Views
329
Gani tpt
G
C
Import JSON documents into SQL Server
Replies
0
Views
87
CSharp Enthusiast
C
G
C# - Error while adding Data Header column in data table
Replies
0
Views
144
Gani tpt
G
G
C# - Error screenshot while adding Data Header column in data table
Replies
0
Views
153
Gani tpt
G
Back
Top