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 |
|
Krishnamani
Starting Member
2 Posts |
 Posted - 2006-03-20 : 02:55:33
|
| Hi, I am using Sql server 2005 express edition, and I want to import a table to text file using express manager. How to use the Management studio to Import the table into text file as using in enterprise manager in Sql server 2000?As many of you may faced this problem, if you can please help me.regards,km. |
|
|
Krishnamani
Starting Member
2 Posts |
Posted - 2006-03-21 : 00:45:09
|
| Hi all, I find the solution for this, just by receiving the results in tsv file or rpt file.by setting the Tools --> Options , Query Resukts in file can be used to Export the data to text file without using Enterprise Manager Export Option. But, now I need to know how to import a text file to database?If anyone find the solution, Please tell me.Thanks,Regards,km. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-21 : 05:50:31
|
use BCP or bulk insert.look that up in BOL = books online = sql server help.if you want a wizard to do it you'll need SQL server Integration Services (that's new DTS)Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
Enterprise Manager vs Management studio?