HOW TO IMPORT DATA FROM EXCEL SHEET TO SQL?

Right-click on the database, there is import and then the next step is OK

1. Select the database you want to import--- task --- import data.

2. Select the excel data source - browse the file. Note: If the first row of data in Excel is a field, select "The first row contains column names".

3. Click Next as prompted, select the server, fill in the verification information and target database.

4. Click Next to determine the type of import.

5. Select the database - select the source table and the original view, if you do not select the target, the table with the same name will be automatically generated in the database and the data will be imported into it.

6. Then the next step by default, no need to save the SSIS package, directly run it immediately by default, and finally click Finish.

Open the Enterprise Manager, find the database you want to import data to, right-click on it, select All Tasks, then select Import Data, select Excel in the data source, go to the next step, and then pay attention to select the column corresponding to the sheet and the corresponding table in your database.

Right-click the target database in SQL Server Management Studio and select Task - Import Data.

Select Excel in the data source and follow the prompts to do it.

This method requires that the tables in Excel are compared regularly**.

Right-click on the database name, there is an "import" item, and you can do it step by step through the prompts.

Here's how:

1. Open the excel file you want to import and observe whether the first column is a field or data.

2. Open sqlserver, right-click [Task] - [Import Data] in the data to be imported

The Import and Export wizard appears.

3. Click Next to enter the [Select Data Source] page, and pay attention to the red box setting.

4. Click Next to enter the [Select Target] page, and pay attention to the red box setting.

5. Click Next to enter the [Copy or Query Specified Table] page, and pay attention to the red box setting.

6. Click Next to enter the [Select Source Table and Source View] page, and pay attention to the red box setting.

7. Next step until completion. The Execution Results Page appears.

8. Finally, query the table in sqlserver.

SQL Server -- Enterprise Manager -- Data Transformation Service.

You can realize your needs.

Method steps.

First of all, we use the sqlyogent tool to connect to the MySQL database.

After the connection is successful, find the desired table in the directory location on the left, and right-click to open the table.

You can also enter :: directly in the SQL executor

select * from datetable name

Open the table.

Below the SQL executor, below the result, on the far left, there is a small icon, and the text "Export As" will appear on top of the mouse movement. Click on this icon.

After clicking, a pop-up window called "Export As" will pop up, select the file format you want to export: such as csv, html, xnl, etc., and select the fields to export on the right.

There is an input box at the bottom of the interface, which is the default export path of the program, or you can click the button next to the path to customize the export file path.

Finally, click the [Export] button, after clicking, there will be a small prompt window, the prompt message is "date exporet successfully", click the [OK] button, to complete the export operation.

Finally, find the exported file in the export directory and check if the export is successful.

It should be noted here that the file in csv format, if you open it with excel, it will be garbled, because the encoding is different, if you open it with txt, there will be no such problem.

One is to use the import function of SQL itself, which you need to do field mapping during the import process.

The second is to write an INSERT statement in excel and run it in SQL, and the third is to write VBA in Excel, link the database with ADODB, and splice SQL statements into the database, which is a bit similar to the second one.

Importing Excel data directly into a table is not supported by SQL Server.

You can only write SQL statements that correspond columns in Excel to fields in tables in SQL.

Insert in order

Select the corresponding database in sqlserver, right-click - Export data, select the data source, Microsoft Excel97-2000, and select Excel file. Next, select the database you want to import to, and next, select Copy tables and views from the database. In the next step, select the table in Excel and the table in sqlserver, click the conversion button to correspond to the field relationship between the two tables, and finally click to complete the step.

Look at what the database is, Oracle, MySQL, SQL Server

How to import an Excel data table into SQL (SQL Server 2008 as an example):

1. First open the database, right-click on the database, move the cursor to the database "Task" and you will see a "Import Data", click Import Data, the following figure will appear.

2. Select the data source and add the file path and version for Excel. Whether the column name is included in the first row.

3. Select the database and authentication you want to store.

4. Select the source table and source view.

5. Then just go to the next step.

Method steps.

1. Open SQL Server Management Studio and follow the path in the figure to enter the Import Data interface.

2. When importing, the Excel file needs to be prepared and cannot be opened. Click Next.

Data source: Select "Microsoft Excel" In addition to Excel data, SQL also supports many other data source types.

Select the Excel file you want to import. Click Browse and find the imported file OK.

Confirm that there is no problem with the file path and click Next.

The default is WinODWS authentication, and SQL authentication is used instead. Enter the database password, note: database, here to see if it is an imported database. You can also change it here to select a different database.

If there are several sheets, or if there are some data in a sheet table that we do not want to import, you can write a query to import the specified data. Click Next.

Select the sheet table we want to import, for example, if I change the name of the sheet table to price, then the SQL database table that imports the new surface is price$. Click to go to the next step.

Click to go to the next step.

Here is a complete display of our import information, execution content, and after confirming that it is correct, click Finish to start the execution.

You can see the process and progress of task execution.

Execution successful: We can look at the execution result, 1754 rows have been transferred, which means that 1754 pieces of data have been imported from the excel sheet, including the column headers. That's it, execute the SQL query statement:

select * from price$ to view the imported data.

From SQL 2008 to the desktop of the computer everywhere the data **:

insert into openrowset('','excel ;database=c: Users jroilee desktop inventory processed. xlsx;',select warehouse category name,warehouse**,warehouse name,commodity class name,price category,commodity**,color name,season name,quantity,amount from [sheet1$].' )

select * from

Explanation: The export file is placed on the desktop in the "Inventory Processed. xlsx" in this excel. Then, the data in the SQL statement must be the same as the exported data header. As follows: