Choose a Destination (SQL Server Import and Export Wizard)
Updated: January 16, 2017
After you provide info about the source of your data and about how to connect to it, the SQL Server Import and Export Wizard shows Choose a Destination. On this page, you provide info about the destination for your data and about how to connect to it.
For info about the data destinations 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 Destination page of the wizard. The rest of the page has a variable number of options which depend on the destination that you choose here.
Specify the destination by selecting a data provider that can import data into the destination.
- 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.
- 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. (SQL Server Native Client and the Microsoft OLE DB Provider for SQL Server are still in the list but are no longer supported.)
- 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.
- 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 Destination 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 destination, the rest of the Choose a Destination page has a variable number of options which depend on the data provider that you choose.
To connect to a commonly used destination, 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
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 destination for your data and about how to connect to it, the next page is Specify Table Copy or Query. On this page, you specify whether you want to copy an entire table or only certain rows. For more info, see Specify Table Copy or Query.