How to pour EXECEL data into ACCESS locally

If you want to convert data from Excel to Access, you can use the following direct import method and link building method to complete it.

First, the direct introduction method.

1.Start Access and create a new database file.

2.In the Table option, execute the File Get External Data Import command to open the Import dialog box.

3.Press the drop-down button to the right of "File Type" and select "Microsoft Excel (.").xls)" option, then locate to the folder where the workbook file needs to be converted, select the corresponding workbook, and press the "Import" button to enter the "Import Data Table Wizard" dialog box (Figure 1).

4.Select the worksheet to be imported (e.g. Project Data), press the Next button several times for further settings, and then press the Finish button.

5.A dialog box will pop up (in the middle of Figure 1) and press the OK button.

At this point, the data is imported from Excel into Access.

2. Establish a link method.

1.Start Access and create a new database file.

2.In the Table option, execute the File Get External Data Link Table command to open the Link dialog box.

3.The following operations are basically similar to the above "direct import method", so I will not repeat them here, please practice them on your own.

Note: Both the "Direct Import Method" and the "Establish Link Method" can convert Excel data into Access, except for the different icons displayed in Access (Figure 2), the biggest difference between the two is that the data converted by the former is disconnected from the data source, while the data converted by the latter will be automatically updated at any time with the change of the data source.

Please give it a point.

It doesn't need to be that much trouble.

1.Manual operation: Create an empty access library, then select "Get External Data" from the Access file menu, then select "Import", and select your excel file in the pop-up dialog box.

**Operation: select * into tmptable from [excel; database="+ Your excel sheet name +"].[sheet name $]."

Access to Excel:

select * into [excel ;database=" & "\ from customers"

Some programmers need to import the data in Excel into the Access database and write another program, because Excel and Access are both Office products, and it is possible to import Excel data into the Access database.

Tool raw materials: excel, access

1. First of all, prepare the excel sheet that needs to be imported, and check that the data is correct.

2. Open the access database, there is an external data above the database, click on the external data to have an "import excel** function", click on the function to start the import operation.

3. Find your Excel, clarify the path, and you can start. Click OK to proceed to the next step.

4. When you start importing, check whether the first line contains the title according to your needs. Tick: The first column in excel is the field name in the database, and unchecked: all the data in excel becomes the data in the database.

5. Next, you can modify the "Field Name" and "Data Type" according to your needs.

7. After completing the setting of the primary key, the import of the data is completed, but it is not finished, and you have to name the imported data. Finally, the operation of importing the data from Excel into the Access database is completed.

You can import the table directly in Access, and the title of the original Excel file needs to be the first row.

1.Double-click the access icon to open the access software.

2.Click Empty Database to create an access document.

3.First, use the direct import method. In the menu bar, select "File" - "Get External Data" - "Import".

4.Select an excel file and click "Import".

5.In the Import Data Table Wizard, select a worksheet and click Finish.

6.A prompt box appears, confirm that it is correct, and click OK to complete the import.

7.See, there is already the data table you just exported in the access file.

8.Then use the link building method. In the menu bar, select "File" - "Get External Data" - "Link Table".

9.Select an excel file and click "Link".

10.Follow the step-by-step method, and after completion, you can see that an excel link table appears in the access file.

Access menu File - Get External Data - Import.

In the dialog box, select Excel as File Type and find your Excel import.

Then you copy the data on excel to your new excel2010, save it and then guide it, 2010 has not been used, try more.

Step 1: Start Access in the Ghost XP system, and create an "empty database" under the prompts of the wizard to store the data imported from Excel.

Step 2: Open the database you want to import data, switch to the "External Data" tab, select the "Excel" button, and open the "Import Data" dialog box.

Step 3: In the "Select Data Source" dialog box, you can select the data source according to your needs, and the data source is the "Grade Sheet" we prepared earlier. xlsx' file. Also select Import data source into a new table in the current database.

Step 3: In the "Select Data Source" dialog box, you can select the data source according to your needs, and the data source is the "Grade Sheet" we prepared earlier. xlsx' file. Also select Import data source into a new table in the current database.

Step 6: Select each data column separately and specify the data type after importing the database. The Chinese part is recommended to be set to "text", and the number part can be set to "integer type" or "double type". Then click on the "Next" button.

Step 7: Next, set the primary key for the data table. The primary key is a special kind of column in the database, the contents of the column are a set of numbers that automatically increase, if there is no actual need, we select "do not have a primary key" and click the "Next" button.

Step 8: Choose a name for the new mark to be generated. For example, "Student Grade Data" and click the "Finish" button to complete the import.