从文本批量导入数据导SQL Server数据表

 

从文本批量导入数据导SQL Server数据表

===========================================================

作者: locker(http://locker.itpub.net)
发表于: 2004.11.26 09:08
分类: SQL Server
出处: http://locker.itpub.net/post/1523/7056
---------------------------------------------------------------

参考样式：

USE master
CREATE DATABASE Accounting
GO
CREATE TABLE Accounting.dbo.Customer (
 CustomerID nchar (5) NOT NULL ,
 CompanyName nvarchar (40) NOT NULL ,
 ContactName nvarchar (30) NULL ,
 ContactTitle nvarchar (30) NULL ,
 Address nvarchar (60) NULL ,
 City nvarchar (15) NULL ,
 Region nvarchar (15) NULL ,
 PostalCode nvarchar (10) NULL ,
 Country nvarchar (15) NULL ,
 Phone nvarchar (24) NULL ,
 Fax nvarchar (24) NULL )
GO

BULK INSERT Accounting.dbo.Customer
 FROM 'C:SelfPacedSQLCH_9NewCustomerData1.txt'
 WITH
 (
  DATAFILETYPE = 'char' ,
  FIELDTERMINATOR = ',',
         ROWTERMINATOR = 'n' )