SQL Server SQL and Excel Data Interchange Import Export

Before the time grammar too much, I think a lot of friends will head big, then say a little easier, excel as a flexible small data manipulation storage software, since the release, received a lot of people's favor, for Excel has a common impression, it is convenient, but when we indulge in it, Can not extricate themselves, the amount of data is too large and bloated, will be a blow to kill us, then we need to consider how to solve the problem of increasing data volume, ok,sql, a data playing in the palm of the data tools, I am very fond of SQL, so, with a bit of SQL to everyone.

Tools/Materials

• SQL Server 2005

• Office 2003

Excel Importing SQL data tables

2. 1

   First of all, I want to tell you the process of this experience, I first look up a table from my database, then export the table information to Excel, and then for the sake of convenience, I will import the Excel table data into the SQL database, of course, will appear as a newly created table. Version 2003 of Office is available later, and the process is similar.

4. 2

   First open the database, as for the database-related operations, I would like to say no more, because these experiences are for almost the entry of friends to see, if you do not know what SQL is a thing, still do not know the basic operation, it is not a pro, this experience really does not suit you oh.

6. 3

   Create a new Excel to import SQL database table data directly from the Excel Data menu. Select the Data menu:

8. 4

   Then select "Import External Data"--"Import data":

10. 5

    Select New SQL Server connection. ODC, double-click:

12. 6

    Next, enter the server name, and then login credentials, if the server is local, you can use "." Directly. or localhost, click Next:

14. 7

    Select the database you want to connect to, select the table you want to export, and then click Next:

16. 8

    Then define a file name and click "Finish":

18. 9

    At this point in the Excel section, the system requires you to specify a location to hold the data.

20. 10

    When you are sure that there is a location, click OK:

22. 11

    OK, we open the corresponding database table to compare, whether the data export is correct:

    END

SQL Import Excel table data

1. 1

   Select the database to import---task---import data:

2. 2

   Select the Excel data source--Browse for the file. Note If the first row of data in Excel is a field, you should tick "First row contains column name".

3. 3

   Follow the prompts to select the server to fill in the verification information and target database after clicking Next:

4. 4

   Click Next to determine the type of import:

5. 5

   Select the database-select the source table and the original view, if the target is not selected, it will automatically generate a table with the same name in the database, and import the data in.

6. 6

   Then by default the next step, without saving the SSIS package, runs directly by default immediately:

7. 7

   Last Click Finish:

   END

Precautions

• Operation is relatively simple, I hope you can have this demand for all the help of friends.

  Ext.: Http://jingyan.baidu.com/article/73c3ce28c839b7e50243d950.html?qq-pf-to=pcqq.group

SQL Server SQL data interchange with Excel import and export