how to import text file content in a database.

hi,

You have several options for inserting data into SQL Server from a text file.
SQL Server Import and Export wizard
http://msdn.microsoft.com/en-us/library/ms141209.aspx

T-SQL BULK INSERT command
http://msdn.microsoft.com/en-us/library/ms188365.aspx

hope this will help you.

0

Pankaj Pandey13y ago

hello

try this, i think it will helpfull for you..

BULK

INSERT Test

FROM 'D:\test.txt'

WITH

(

FIELDTERMINATOR = '|',

ROWTERMINATOR = '\n'

)

0

Sunny Sharma13y ago

Hi Fiston,

use the sample below to achieve this purpose:

BULK INSERT from 'D:\\test.txt' with (FIELDTERMINATOR='|', ROWTERMINATOR='\n')

this will import all the records into your table.

Please don't forget to mark it as answer if it helps!
Thanks.

0