Export Excel File Into Access 2013

Introduction

In this article I will explain how to export an Excel file to Access 2013. The steps are as follows.

Step 1

First open Access 2013 and select blank database and give a name to the database and click on create.

access3.jpg

Step 2

Enter some data to your Access file, as in:

access9.jpg

Step 3

Now select the External data menu as:

access4.jpg

Step 4

In this select Export Excel option as:

access5.jpg

Step 5

The Excel file name option is opened; enter the name and path of where you want your Excel file to be saved, by default it is the name of the table in your Access database.

access6.jpg

Step 6

Now go to that location where your Excel file is stored and open it; it will have the same content as your Access database, as in:

access8.jpg

In this way we can export an Excel file to an Access file.


Similar Articles