CODEWITHSUNDEEP
sql-serverdatabasessms
BlackCat
BlackCat

Reputation: 2044

Importing text files without column name into database table

I have an empty table "BTS" with three columns in sql server

and a delimited text file with data(No Column Name,only row data)

I want to import data from text file to "BTS"

While I am trying this using import export wizard in ssms ,it is trying to take first row of text file as column names,what should I do to get rid of this?

Upvotes: 2

Views: 1526

Answers (1)

yuvi
yuvi

Reputation: 574

While importing data in table through ssms,

In data source tab where as you will be selecting the flat file to import,please uncheck the option"column names in the first data row" which will not read the column name

Upvotes: 5

Related Questions