Import data to a new SQL Server table

This topic explains how to import data to a new SQL Server table using the Data Import wizard.

To import data to a new table:

1. Open the Data Import wizard in one of these ways:

  • On the Start Page, select Data Pump > Import External Data.

  • In Database Explorer, right-click the required database or server connection and select Tasks > Import Data.

  • In Database Explorer, right-click the required table or view and select Import Data.

  • On the menu bar, select Database > Tasks > Import Data.

2. On the Source file page, select the file format and specify the source document, then click Next.

Tip

Click Load Template to load import options from a previously saved template file.

Select the CSV format

3. On the Destination page, select the target table for the data import, then click Next.

Select the destination table

4. Configure the import options for the selected data format, then click Next.

  • Text

  • Microsoft Excel (XLS)

  • Microsoft Excel 2007+ (XLSX)

  • Google Sheets

  • Microsoft Access

  • XML

  • JSON

  • CSV

  • ODBC

  • DBF

5. Click Import.