Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
u133189
Starting Member
2 Posts |
 Posted - 2014-01-03 : 02:53:32
|
| Dear All,I am looking solutions to import csv data into my SQL database table.BUT we want to collect the data from specific columns in the csv file, (NOT the whole csv file) into SQL Database Table.Could anyone help me on this?Thanks and Regards,Edward |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-01-03 : 03:33:53
|
In Management Studio - Object Explorer right click on the database where you want to store the data.Then in context menu click "Tasks" and then "Import Data..." and then follow the wizzard.
Too old to Rock'n'Roll too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
u133189
Starting Member
2 Posts |
Posted - 2014-01-03 : 03:49:05
|
Thank you for your help. This is what I need. You are my great helper.CheersEdwardquote:
Originally posted by webfred
In Management Studio - Object Explorer right click on the database where you want to store the data.Then in context menu click "Tasks" and then "Import Data..." and then follow the wizzard.
Too old to Rock'n'Roll too young to die.
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-01-03 : 04:32:14
|
You are welcome 
Too old to Rock'n'Roll too young to die. |
|
|
|
|
|
|
import certain csv columns data into SQL database