Choose a Data Source (SQL Server Import and Export Wizard)
Updated: February 16, 2017
After the Welcome page, the SQL Server Import and Export Wizard shows Choose a Data Source. On this page, you provide info about the source of your data and about how to connect to it.
For info about the data sources that you can use, see What data sources and destinations can I use?
The following screen shot shows the first part of the Choose a Data Source page of the wizard. The rest of the page has a variable number of options which depend on the data source that you choose here.
Specify the data source by selecting a data provider that can connect to the source.
- The data provider that you need is typically obvious from its name, because the name of the provider typically contains the name of the data source - for example, SQL Server, Oracle, flat files, Excel, or Access.
- If you have an ODBC driver for your data source, select the .Net Framework Data Provider for ODBC. Then enter the driver-specific info. ODBC drivers aren't listed in the drop-down list of data sources. The .Net Framework Data Provider for ODBC acts as a wrapper around the ODBC driver.
- There may be more than one provider available for your data source. Typically you can select any provider that works with your source. For example, to connect to Microsoft SQL Server, you can use the .NET Framework Data Provider for SQL Server or the SQL Server ODBC driver. (Other providers are also still in the list but are no longer supported.)
- You may have to download the data provider from Microsoft or from a third party. For info about the data sources that you can use, see What data sources and destinations can I use?
The list of available data providers in the Data source list depends on the providers installed on your computer. It also depends on whether you're running the 64-bit or the 32-bit wizard. If you're running the 64-bit wizard, for example, you won't see data sources for which only a 32-bit provider is installed.
After you choose a data source, the rest of the Choose a Data Source page has a variable number of options which depend on the data provider that you choose.
To connect to a commonly used data source, see one of the following pages.
- Connect to SQL Server
- Connect to Oracle
- Connect to flat files (text files)
- Connect to Excel
- Connect to Access
- Connect with ODBC
- Connect to Azure Blob Storage
- Connect to PostgreSQL
- Connect to MySQL
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.
After you provide info about the source of your data and about how to connect to it, the next page is Choose a Destination. On this page, you provide info about the destination for your data and about how to connect to it. For more info, see Choose a Destination.