数据导入导出问题(50分)

sql server 中有数据导入导出功能，现在我需要在程序中实现把sql server中的数据
导入到文本文件中，每个表导到一个文本文件。然后再从这个文本文件中导到sql server
数据库中。

哪种sql server

sql server 2000

下个dtssetup(MS DTS Wizard).exe

to : goodpbl
那有

Haven't got a Chinese editor with me, and have to use English today.

1. In SQL 2000 and SQL 7, there is Data Transformation Services (DTS) facility
which you can use to import / export data.

2. DTS can be packaged (打包), and scheduled to run as a regular job.

3. If you only want to export / import data (SQL - text file) as a one-off job,
you can actually just use the Data Import/Export Wizard.

To do that, in Enterprise Manager:
select an item (eg, table or view)-> right click -> All tasks ->
import data or export data ->choose data source, destination (text file name)
->......

This is the standard MS Wizard, and should be easy to follow.

Note: Suggest you doing a backup before data transport.

Good Luck

多人接受答案了。