How does the data in Excel import into an Access database?

Most people now record data in Excel, but some programmers need to import data from Excel into an Access database and write an additional program, but it's tough for beginners, So now I'm going to explain how to import data from Excel into an Access database.

Find the Excel and access you need to make changes

In order to avoid their own future, so the first step seems irrelevant, but indispensable. Make sure that the data in Excel is imported into the database don't go wrong, otherwise it's all in vain.

Create a new database and start the operation

There is an external data above the database, click on the external data there is an "Import Excel table Function", click the feature to start the import operation.

Find your own Excel, clear the path, and you can start. Click OK to go to the next step

At the beginning of the import, check to see if the first row contains the title, depending on your needs.

TICK: The first column in Excel is the name of the field in the database

No tick: All data on behalf of Excel becomes data in the database

I'll show you The Tick

On the next page, you can modify the field name and data type to suit your needs.

Go to the next page, you can modify the primary key in the database, you can use the default primary key of access, you can also customize the primary key, or do not have a primary key.

After you finish setting up the primary key, you are finished importing the data, but you are not finished, you want to name the imported data. Finally, you complete the operation of importing data from Excel into an Access database.

The above is the data in Excel how to import into Access database method Introduction, hope to be helpful to everybody!