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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ho to move notepad data to SQL

Author  Topic 

oanise
Starting Member

4 Posts

Posted - 2010-02-25 : 22:15:04
hi. i have a .txt file in notepad which i want to move to my SQL database. it has 1 column of values and i want to move this to one column in my database table.
i don't know how to use SqlBulkCopy or Streamreader.
pls help.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-02-25 : 22:33:03
you can also use BCP or BULK INSERT

http://msdn.microsoft.com/en-us/library/ms188365.aspx
http://msdn.microsoft.com/en-us/library/ms162802.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-02-25 : 23:29:24
Or you can alternatively use SSIS if you want conditional import.

PBUH
Go to Top of Page
   

- Advertisement -