how to add column name after importing

[hlmnsbuggy]

Hello
I got .csv data file and .sql file from outside company, Since .csv data has no column names, after I import to SQl, the column names show col1, col2, col3, etc. They also send me column name separately in .sql file format. I need to know how to replace default col names with correct column names

Please explain to me in details since I am a begineer for SQL

thanks!

 

[mrdenny]

Use the .sql file to create the table first. Then import the data into that table.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com