HOW TO IMPORT AN EXCEL DATA TABLE INTO SQL

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.

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

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:

First of all, do not install the simplified version of SQL (Express), which does not have an import function.

Open SQL Manager, right-click on the database you want to import, and select Task - Import Data.

Select Excel as the data source, then select the Excel file you want to import, and follow the wizard.

Use the DTS import and export tool that comes with SQL.

1. Turn on DTS

2. Select the Excel** you want to import.

3. The target database to be imported.

4. Select whether to import all or part of the content.

5. Select the workbook and destination you want to import.

It should be noted that the first row of Excel will be treated as a column name. So to import the first line, you can insert an empty line.