啟動 SQL Server 匯入和匯出精靈Start the SQL Server Import and Export Wizard

如需舊版 SQL Server 的相關內容,請參閱執行 SQL Server 匯入和匯出精靈For content related to previous versions of SQL Server, see Run the SQL Server Import and Export Wizard.

使用本主題中所述的其中一種方式來啟動 [ SQL ServerSQL Server 匯入和匯出精靈],以從中匯入資料,並將資料匯出至任何支援的資料來源。Start the SQL ServerSQL Server Import and Export Wizard in one of the ways described in this topic to import data from and export data to any supported data source.

重要

本主題僅描述如何 啟動 精靈。This topic describes only how to start the wizard. 如需其他資訊,請參閱相關的工作及內容If you're looking for something else, see Related tasks and content.

您可以啟動精靈:You can start the wizard:

必要條件 - 電腦上已安裝精靈嗎?Prerequisite - Is the wizard installed on your computer?

如果您想要執行精靈,但電腦上尚未安裝 MicrosoftMicrosoft SQL ServerSQL Server ,則可以安裝 SQL Server Data Tools (SSDT) 來安裝 [ SQL ServerSQL Server 匯入和匯出精靈]。If you want to run the wizard, but you don't have MicrosoftMicrosoft SQL ServerSQL Server installed on your computer, you can install the SQL ServerSQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). 如需詳細資訊,請參閱 下載 SQL Server Data Tools (SSDT)For more info, see Download SQL Server Data Tools (SSDT).

注意

若要使用 64 位元版本的 [SQL Server 匯入和匯出精靈],您必須安裝 SQL Server。To use the 64-bit version of the SQL Server Import and Export Wizard, you have to install SQL Server. SQL Server Data Tools (SSDT) 和 SQL Server Management Studio (SSMS) 是 32 位元應用程式,而且只會安裝 32 位元檔案 (包含 32 位元版本的精靈)。SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are 32-bit applications and only install 32-bit files, including the 32-bit version of the wizard.

[開始] 功能表Start menu

從開始功能表中啟動 SQL Server 匯入和匯出精靈Start the SQL Server Import and Export Wizard from the Start menu

  1. 在 [開始] 功能表上,找出並展開 [Microsoft SQL Server 2016]。On the Start menu, find and expand Microsoft SQL Server 2016.
  2. 按一下下列其中一個選項。Click one of the following options.

    • SQL Server 2016 匯入和匯出資料 (64 位元)SQL Server 2016 Import and Export Data (64-bit)

    • SQL Server 2016 匯入和匯出資料 (32 位元)SQL Server 2016 Import and Export Data (32-bit)

    除非您確定資料來源需要 32 位元資料提供者,否則請執行 64 位元版本的精靈。Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.

    啟動精靈 (開始)

Command promptCommand prompt

從命令提示字元中啟動 SQL Server 匯入和匯出精靈Start the SQL Server Import and Export Wizard from the command prompt

在命令提示字元視窗中,執行下列其中一個位置的 DTSWizard.exeIn a Command Prompt window, run DTSWizard.exe from one of the following locations.

  • C:\Program Files\Microsoft SQL Server\130\DTS\Binn (適用於 64 位元版本)。C:\Program Files\Microsoft SQL Server\130\DTS\Binn for the 64-bit version.

  • C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn (適用於 32 位元版本)。C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn for the 32-bit version.

除非您確定資料來源需要 32 位元資料提供者,否則請執行 64 位元版本的精靈。Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.

啟動精靈 (Cmd)

SQL Server Management Studio (SSMS)SQL Server Management Studio (SSMS)

從 SQL Server Management Studio (SSMS) 啟動 SQL Server 匯入和匯出精靈Start the SQL Server Import and Export Wizard from SQL Server Management Studio (SSMS)

  1. Transact-SQLSQL Server Management Studio中,連接到 SQL ServerSQL Server Database EngineDatabase Engine的執行個體。In Transact-SQLSQL Server Management Studio, connect to an instance of the SQL ServerSQL Server Database EngineDatabase Engine.

  2. 展開 [資料庫]Expand Databases.

  3. 以滑鼠右鍵按一下資料庫。Right-click a database.
  4. 指向 [工作] 。Point to Tasks.
  5. 按一下下列其中一個選項。Click one of the following options.

    • 匯入資料Import Data

    • 匯出資料Export Data

    啟動精靈 (SSMS)

如果您未安裝 SQL Server,或您有 SQL Server 但未安裝 SQL Server Management Studio,請參閱下載 SQL Server Management Studio (SSMS)If you don't have SQL Server installed, or you have SQL Server but don't have SQL Server Management Studio installed, see Download SQL Server Management Studio (SSMS).

Visual StudioVisual Studio

使用 SQL Server Data Tools (SSDT) 從 Visual Studio 啟動 SQL Server 匯入和匯出精靈Start the SQL Server Import and Export Wizard from Visual Studio with SQL Server Data Tools (SSDT)

在具有 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)的 Visual Studio 中開啟 Integration Services 專案,然後執行下列其中一個動作。In Visual Studio with SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT), with an Integration Services project open, do one of the following things.

  • 在 [專案] 功能表上,按一下 [SSIS 匯入和匯出精靈] 。On the Project menu, click SSIS Import and Export Wizard.

    啟動精靈 (專案)

    - 或 -- or -

  • 在方案總管中,以滑鼠右鍵按一下 [SSIS 封裝] 資料夾,然後按一下 [SSIS 匯入和匯出精靈] 。In Solution Explorer, right-click the SSIS Packages folder, and then click SSIS Import and Export Wizard.

    啟動精靈 (封裝)

如果您未安裝 Visual Studio,或您有 Visual Studio 但未安裝 SQL Server Data Tools,請參閱下載 SQL Server Data Tools (SSDT)If you don't have Visual Studio installed, or you have Visual Studio but don't have SQL Server Data Tools installed, see Download SQL Server Data Tools (SSDT).

取得精靈Get the wizard

如果您想要執行精靈,但電腦上尚未安裝 MicrosoftMicrosoft SQL ServerSQL Server ,則可以安裝 SQL Server Data Tools (SSDT) 來安裝 [ SQL ServerSQL Server 匯入和匯出精靈]。If you want to run the wizard, but you don't have MicrosoftMicrosoft SQL ServerSQL Server installed on your computer, you can install the SQL ServerSQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). 如需詳細資訊,請參閱 下載 SQL Server Data Tools (SSDT)For more info, see Download SQL Server Data Tools (SSDT).

在精靈執行時取得說明Get help while the wizard is running

提示

在精靈的任何頁面或對話方塊中點選 F1 鍵,以查看目前頁面的文件。Tap the F1 key from any page or dialog box of the wizard to see documentation for the current page.

下一步What's next?

當您啟動精靈時,第一頁是 [歡迎使用 SQL Server 匯入和匯出精靈] 。When you start the wizard, the first page is Welcome to SQL Server Import and Export Wizard. 您不需要在此頁面上採取任何動作。You don't have to take any action on this page. 如需詳細資訊,請參閱 歡迎使用 SQL Server 匯入和匯出精靈For more info, see Welcome to SQL Server Import and Export Wizard.

以下是一些其他基本工作。Here are some other basic tasks.