Welcome to SQL Server Import and Export Wizard
Use the SQL Server Import and Export Wizard to copy and transform data between supported data sources and destinations.
To learn more about this wizard, see Importing and Exporting Data by Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, and about the permissions required to run the wizard successfully, see How to: Run the SQL Server Import and Export Wizard.
The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.