Sunday, 28 August 2011
Insert Into Sql Table from Formatted Text File
use
DBName
BULK INSERT
dbo.Table_1
FROM
'c:\textFileName.txt'
WITH
(
FIELDTERMINATOR
=
'\t'
,
--Tab
ROWTERMINATOR
=
'q'
--Char 'q'
);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment