Reader Level:
Article
Microsoft Office

Export Excel File Into Access 2013

By Richa Garg on Aug 22 2012
In this article I will explain how to export an Excel file to Access 2013.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 12.4k
  • 0

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.