"Access2007" imports an Excel table into one of the existing tables in Access2007

Import the Excel table into Access2007 and you will find that the evil Access2007 will help you create a table yourself. Never asked if you want to insert a table that already exists.

So, we need to solve this problem:

First, follow the normal steps to import the Excel table into Access2007

1. Select "External Data" on the tab bar->excel

2. Select the Excel file you want to import from the specified data source in the popup dialog box, and click "OK"

3. Select the worksheet point to import next

4, see if this table is the first column includes the table header, which is generally included. Tick the first line including the column headings. Click Next, and then click Next.

5, choose not the primary key, click Next

6, after the choice is over, you will find that the evil Access2007 will help you to create a table, completely did not ask whether you want to insert an existing table

Import an Excel table into one of the existing tables in Access2007,

Ii. merger of two tables

If you want to put the whole contents of Sheet1 's username and password into test:

In SQL view, it will not open. Can read my previous article "Access2007" Change database Password and input SQL statement query "(click the Open link),

Input:

INSERT into Test (username,password) select * from Sheet1;

Click on the top left corner of the run, pop up the OK box to choose to run it.

"Access2007" imports an Excel table into one of the existing tables in Access2007