Usually, when dealing with customer data, we face a large amount of data import work. Manual import is too slow, and the processing is also cumbersome, and the work efficiency is low. At this time, we can use some tools to assist our work, thereby improving our work efficiency and further achieving our goals. Here we take SQL server2008 For example, the following is an example of importing data from an Excel spreadsheet into SQL to extract relevant data information more quickly.
1, Open SQL Server, select the database you want to import, and click on it in sequence:" Right click on Database - Tasks - Import Data , as shown in the figure;
2, Select the source data as Microsoft Excel and select the location of the Excel file, as shown in the figure;
3, Log in using SQL Server authentication and select the corresponding database (the system will default to the database you initially selected), as shown in the figure;
4, Select the table where the data needs to be imported, and select "ignore" when viewing the data type, as shown in the figure;
5, After completing the above steps, click on the next step directly, and the prompt "successful" indicates that the data has been imported successfully;
