Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
The topics in this section show you how to connect to many commonly used data sources when you run the SQL Server Import and Export Wizard. You have to provide connection info for your data sources on the Choose a Data Source and Choose a Destination pages of the wizard.
The topics in this section describe only how to connect to data sources from the Choose a Data Source and Choose a Destination pages of the wizard. If you're looking for something else, see Related tasks and content.
Click a link to learn more about connecting to one of the following commonly used data sources.
For info about how to connect to a data source that's not listed here, see The Connection Strings Reference. This third-party site contains sample connection strings and more info about data providers and the connection info they require.
Here are some other basic tasks.
See a quick example of how the wizard works.
If you prefer to see screen shots. Take a look at this simple end-to-end example on a single page - Get started with this simple example of the Import and Export Wizard.
If you prefer to watch a video. Watch this four-minute video from YouTube that demonstrates the wizard and explains clearly and simply how to export data to Excel - Using the SQL Server Import and Export Wizard to Export to Excel.
Learn more about how the wizard works.
Learn more about the wizard. If you're looking for an overview of the wizard, see Import and Export Data with the SQL Server Import and Export Wizard.
Learn about the steps in the wizard. If you're looking for info about the steps in the wizard, see Steps in the SQL Server Import and Export Wizard. There's also a separate page of documentation for each page of the wizard.
Start the wizard. If you're ready to run the wizard and just want to know how to start it, see Start the SQL Server Import and Export Wizard.
Get the wizard. If you want to run the wizard, but you don't have Microsoft SQL Server installed on your computer, you can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Get data in Power BI - Training
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Import and Export Data with the SQL Server Import and Export Wizard
Choose a Destination (SQL Server Import and Export Wizard) - SQL Server Integration Services (SSIS)
Choose a Destination (SQL Server Import and Export Wizard)
Steps in the SQL Server Import and Export Wizard - SQL Server Integration Services (SSIS)
Steps in the SQL Server Import and Export Wizard