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 |
|
shwetabrahme
Starting Member
4 Posts |
 Posted - 2006-03-04 : 14:03:45
|
| i have a txt file containing lot of data..however i want bulk insert some of the rows in the database....is it possible to do it using any particular insert query...if yes can anybody suggest me the kind of query to be written for the same |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-04 : 16:18:22
|
insert the whole file into a temporary staging table and insert desired rows from there.Go with the flow & have fun! Else fight the flow  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-06 : 00:41:19
|
| egBulk insert to stagingtableInsert into yourTable(columns)Select columns from stagingtablewhere <condition>MadhivananFailing to plan is Planning to fail |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-03-06 : 01:50:34
|
| use openrowset to query your text file Insert into Table Name (columns)select columns from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\a.csv;','select * fromMyCsv.csv')where <condition> |
|
|
|
shwetabrahme
Starting Member
4 Posts |
Posted - 2006-03-06 : 11:38:43
|
| hey thnx a lot all of u!! |
|
|
|
|
|
|
selective insert