How to import data from one excel table into another table

Import method: 1. Open Table B, click "Data" - "From Access"; 2. Select the "All Files" option in the pop-up window; 3. Select "Table A File" and click "Open"; 4. Select "Sheet Page" and click "OK"; 5. Select "Table" and "Existing Worksheet", and then click "OK".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Import data from one table into another table in excel

Click "View" -> "View Side by Side" and see that there is no data in Test1.xlsx , the purpose is to import the data in Test into Test1. That is, the data of A is imported into B.

In table B, click "Data"->"From Access".

Click the "drop-down box" here in "Access Database".

Select the "All files" option.

Select "Table A File" and click "Open".

Select "Sheet Page" and click "OK".

Select "Table" and "Existing Worksheet" and click "OK".

Finally the data is copied.

Related learning recommendations:excel tutorial

The above is the detailed content of How to import data from one excel table into another table. For more information, please follow other related articles on the PHP Chinese website!