Since almost every organization grows gradually, there are many instances where the organization starts maintaining its database in MS Excel sheet, and then it may want to switch to MS Access 2013 in order to manage the complete database more efficiently and easily.
Considering the above situation, MS Access 2013 allows the database administrators to import all the records from an MS Excel spreadsheet into an Access database. Because of this feature, the database administrators can save their decent amount of time which they would otherwise had to spend if they had to type each record in the MS Access 2013 database manually.
In this tutorial you will learn how you can import the records from an MS Excel spreadsheet to an MS Access 2013 database. Although you can append the records from an MS Excel sheet to an existing table in MS Access 2013 database, it is always a good idea to create a new table while importing in order to avoid any redundant entries or information conflicts.
Below are the instructions that will guide you through the process of importing MS Excel records to MS Access 2013 database:
- Log on to the computer with appropriate account credentials.
- Make sure that MS Access 2013 is successfully installed on the computer and is running flawlessly.
- Create a new database in MS Access 2013 using the required process.
- Once done, go to the EXTERNAL DATA tab.
- From the Import & Link section in the ribbon, click the Excel icon.
- From the opened Get External Data – Excel Spreadsheet box, click the Browse button to browse and locate the Excel spreadsheet from where the records are to be imported.
- From the available radio buttons, make sure that the Import the source data into a new table in the current database one is selected.
- Click OK to continue.
- On the next box that appears, click to select the appropriate radio button.
- Click to select the correct Excel sheet from the available list.
- Click Next to proceed.
- On the next box, if required, check the First Row Contains Column Headings checkbox.
- Click Next to continue.
- On the next box, leave everything as default and click the Next button to continue.
- On the next interface, choose appropriate radio button to specify Primary Key for the selected table.
- Click Next to proceed.
- On the final window, type a unique table name in the available field.
- Finally click Finish to proceed with the record importing process in the newly generated table.