how to solve this error when insert data from Excel
row 1: Cannot insert explicit value for identity column in table ‘fcr_detail_actual’ when IDENTITY_INSERT is set to OFF.
Remove the column in the excel for the Identity Column, or enable IDENTITY_INSERT for the column as per the message.
thanks so much i remove the colom for indentity and not error againt,
but the massage say
“Imported 7 of 7 records from upload_detail.xlsx successfully”
but records inserted only the last line in excel,
how i fix this case
its solve by Import records by transaction in Advanced Settings for Import
is there any idea to be able to speed up the import process.
I import 7 lines in excel that take 1 to 2 minutes