{"id":5339,"date":"2014-04-13T06:05:11","date_gmt":"2014-04-12T21:05:11","guid":{"rendered":"http:\/\/fujiitoshiki.com\/improvesociety\/?p=5339"},"modified":"2014-07-31T13:33:46","modified_gmt":"2014-07-31T04:33:46","slug":"how-to-bulk-insert-from-text-file-to-the-table-which-primary-key-is-identity-constrained-column","status":"publish","type":"post","link":"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=5339","title":{"rendered":"How to BULK INSERT from text file to the table, which primary key is IDENTITY-constrained column?"},"content":{"rendered":"

I’d like to describe how to BULK INSERT from text file to the table with IDENTITY-constrained primary key. You should insert a column into worksheet for primary key such as ‘AUTO_ID’. <\/p>\n

\"TEXTfile\"<\/a><\/p>\n

Transact-SQL code is following list. [Table] is table name, FullPath is complete file-path, and FileName is name of text file, respectively. WITH option phrase represents the first row is title. <\/p>\n

\r\nBULK INSERT dbo.[Table] FROM 'FullPath\\FileName.txt' WITH (FIRSTROW = 2);\r\n<\/pre>\n