SQL Server2008 Export Data Excel detailed parsing _mssql2008

Recently in looking at the database of books and videos, I think the database import and export is very useful, by the way to do a summary, lest there will be forgotten Ah! In fact, import and export is very similar, the idea is the same, there are import and export text, acess,excel and so on templates are very similar, so I summarized export Excel bar. Here's a look at the steps:

1, the first thing to prepare is to create an Excel table on your computer (I created it on the desktop) as shown (is empty):

2, in the SQL Server2008 Enterprise Manager to select the database you want to export, as shown in the figure.

3. Right-click Select Task----> Export Database

4, click the Export data, appear as the diagram interface.

5, click Next button, there will be a selection of Data Source dialog box to export data, as shown in the figure.

6, click Next button, the Selection Purpose dialog box appears, as shown in the figure.

Select the target you want (I'm here to choose Microsoft Excel), and then the following interface will appear:

Then change the Excel file path, as well as the Excel version.

7. After you select the target database, click Next, and the specified table copy or Query dialog box appears, as shown in the figure.

Select "Copy data from one or more tables or views"

8, click the Next button, the Select Source table and View dialog box appears, as shown in the figure.

You can choose more than one, and I have chosen a. Here you can preview the data as shown here:

You can also edit mappings:

9, click the Next button, you will be saved, run the Package dialog box, as shown in the figure.

10, click Next button, you will complete the wizard dialog box, as shown in the figure.

Click Finish, execute successfully!

Below you can view the data in the Excel table! As shown in figure: