Import the TXT file into the SQL statement in SQL Server

admin · Posted on 2/4/2015 5:05:44 PM

[mw_shl_code=sql,true] DROP TABLE tb;
CREATE TABLE tb(name1 NVARCHAR(255),pwd NVARCHAR(255));

bulk insert tb from 'H:\Thunder Download\G1mail.txt'
WITH
(
      FIELDTERMINATOR =':' ,-- column separator
      ROWTERMINATOR = '\n', --row separator
FIRSTROW = 1 , -- Specifies the row number of the first row to load. The default value is the first line in the specified data file
LASTROW = 4929076, -- Specifies the line number of the last line to load
  CHECK_CONSTRAINTS, --Specifies that all constraints on the target table or view must be checked during a bulk import operation
  DATAFILETYPE = 'widechar',
  KEEPIDENTITY
)

GO

select top 100 *from tb; [/mw_shl_code]

[Tips] Import the TXT file into the SQL statement in SQL Server

Related Posts