Import the Excel table into Access2007 and you will find the evil Access2007 which will help you to actively create the table yourself. Do you want to insert at all without asking you to an existing table.
Then, we need to solve this problem:
First, the usual steps to import the Excel table into Access2007
1. Select "External Data" on the tab bar->excel
2. Select the Excel file to import from the specified data source in the popup dialog box. Click "OK"
3. Select the worksheet point to import next
4, see if this table is the first column includes the table header. Generally included, put the first line including the column headings on the hook, click Next, then click Next
5, choose not the primary key, click Next
6, after the selection is complete. You will find that the evil Access2007 will help you to create a table without asking if 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. Will not open, you can read my previous article "Access2007" Change database Password and input SQL statement query "(click the Open link),
Enter:
INSERT into Test (username,password) select * from Sheet1;
The upper-left corner of the run. Ok box pops up and you can choose to run.
"Access2007" imports the Excel table into Access2007 in the existing table as