Try this query to bulk insert data from a file
syntax: Quote:
BULK INSERT TableName
FROM 'filepath'
WITH
(
FIELDTERMINATOR = ' |',
ROWTERMINATOR = '|\n'
)
|
example:
Quote:
BULK INSERT AdventureWorks.Sales.SalesOrderDetail
FROM 'f:\orders\lineitem.tbl'
WITH
(
FIELDTERMINATOR =' |',
ROWTERMINATOR =' |\n'
)
|