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 |
|
ramu143
Yak Posting Veteran
64 Posts |
 Posted - 2008-06-24 : 05:29:32
|
| how to import data into sql and export from sqlserveris there any options are there or else any command directly type and executeautomatically data will dump into new one |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-24 : 05:34:44
|
| You've several options1.use OPENROWSET2.Export/Import wizard3.link the server as linked server and use OPENQUERY |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-06-24 : 05:34:46
|
| If it is SQL Server 2000, you can use DTS/BCP utility/Bulk Insert statement.If it is 2005, you can use SSIS/BCP utility/Bulk Insert statement.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
importing and exporting