How to insert data from text file into my table?

Question

I have text files which contain one word per line, and I would like to add this content to a column in my table, the column type is Varchar, how can I accomplish that?

There are many ways to do this. Is there any specific technology you'd prefer to use? Anything you want to avoid? — Mark Byers
– Mark Byers, Commented Dec 30, 2010 at 2:41

Mark Byers · Accepted Answer · 2010-12-30 02:28:02Z

2

You can treat your file as a special case of CSV - it's a CSV file with only one column.

See this article for how to bulk insert from a CSV file.

BULK
INSERT CSVTest
FROM 'c:\csvtest.txt'
WITH
(
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n'
)
GO

answered Dec 30, 2010 at 2:28

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hallie · Accepted Answer · 2010-12-30 02:46:38Z

0

You can also use import wizard provided in the management studio. You can check this link for your reference.

answered Dec 30, 2010 at 2:46

hallie

2,83320 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to insert data from text file into my table?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related