How to import from CSV to Sql when column is identity

Question

column Id in table is identity ,how to update column id to sql tables importing from CSV

Amit Mohanty · Answer

You can use SqlBulkCopy object to copy data from the CSV file to the database table. string csvPath = @"C:\YourCsvFile.csv"; string tableName = "YourTableName"; string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); // Create a DataTable to hold the CSV data. DataTable csvData = new DataTable(); using (OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [" + tableName + "]", @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + csvPath + ";Extended Properties='Text;HDR=YES;FMT=Delimited'")) { adapter.Fill(csvData); } // Use a SqlBulkCopy object to copy the data from the DataTable to the database table. using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection)) { bulkCopy.DestinationTableName = tableName; bulkCopy.WriteToServer(csvData); } connection.Close();

Jignesh Kumar · Answer

Hello MEghana, You can refer this one which will help you out, https://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-csv-file-records-into-sql-server-database-using-as/

Meghana M · Answer

not using import wizard ,using C# console application

Jignesh Kumar · Answer

If you are using import wizard then you need to enable insert identity, https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/

How to import from CSV to Sql when column is identity

Answers (4)