How to export file into excel from Microsoft Access

Показать описание

Follow this step by step guide to learn how to export a database from Access to Excel where you can view it in the form of a spreadsheet.

A database is a tool for collecting and organizing information. Databases can store information about people, products, orders, or anything else. Using MS Access, you can add new data to the database, edit existing records, delete unwanted records and organize it in the way that best suits your requirements. Furthermore, you can share it with people. You can export Access into Excel if you want to use the Access Database and make calculations in it in Excel. The transition from database format to excel spreadsheet will be smoothly done.

In this tutorial, we will teach you how to export Access to Excel.

Step # 1 -- Converting file

In this tutorial, we first clicked on the products table then on the "external data" tab. Click on the "excel" button located in the "export" group. A dialogue box will appear as a result with which you can export Access to Excel.

Step # 2 -- Saving the file

The dialogue box will ask you where you want to save the file. Click on the browse button in order to select the location where you want the file to be saved.

Step # 3 -- Checking the export button

After specifying the location of the file, you will be returned to the same dialogue box. Over here, check the first two export options. Click on the "ok" button to proceed further.

The two options will export the file from access to excel and it will open it in excel once you close this window.

Step # 4 -- Excel View

Microsoft Excel will open and show you the data you exported from Microsoft Access. In the previous step, you selected the second option which meant that after the conversion has taken place, the file will automatically open in excel sheet.