SQL Server: Create Table using first row of Text File as Column names

Question

How can I read the first row of a text file (comma separated) and use that as the field names of a new table I want to create in SQL Server?

The field names can all be varchar.

Thanks all

UPDTAE

Please note I would like to do this using T-SQL or any other way (sqlcmd etc). I do not want to use the wizard.

D'Arcy Rittich · Accepted Answer · 2010-01-12 15:51:08Z

3

Use the import data wizard (right-click database/Tasks/Import Data...). Select flat file as your Data Source, and check the checkbox "Column names in the first data row".

answered Jan 12, 2010 at 15:51

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

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

3 Comments

Abs Over a year ago

I want to do this in an automated way, sorry I should of stated this.

HLGEM Over a year ago

And since you can save this a sn SSIS package and schedule it as a job, it is the best way to get an automated process.

Abs Over a year ago

Some of my clients may not be using SSIS and I need this coupled with the rest of my script which exports data back out as a text file.

Jose Chama · Accepted Answer · 2010-01-12 16:02:39Z

1

Have you tried to use OPENROWSET?

answered Jan 12, 2010 at 16:02

Jose Chama

2,97818 silver badges22 bronze badges

Collectives™ on Stack Overflow

SQL Server: Create Table using first row of Text File as Column names

UPDTAE

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

UPDTAE

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related