MS Access - Data Export
Ms access tutorial
MS Access - Exporting data
In this chapter, we will understand how to export data from Access. Exporting data is actually the opposite of importing data. When importing data we bring data from other formats into Access, while when exporting we save the data in other formats.
To understand what kind of data you can export from Access data, let us open your database go to the External Data tab.
In the Export group, you can see the different types of options available for exporting data from Access. Here are the most commonly used data export formats -
- Microsoft Office Excel
- Microsoft Office Access
- ODBC databases (For example, SQL Server)
- Fichiers text (delimited or fixed width)
- XML files
Let's look at a simple example of exporting data from Access. Open your database from which you want to export data. In the navigation pane, select the object from which you want to export data.
You can export data from table, query, form and report objects, etc. Let's select the qryAllProjects then go to the External Data tab.
On the External Data tab, click the type of data you want to export to. For example, to export data in a format that can be opened by Microsoft Excel, click Excel.
Access starts the export wizard. In the wizard, you can set the information such as the name and format of the destination file, s 'must include formatting and layout, records to export. Once you are done with the required information, click Ok.
On this wizard screen, Access usually asks you if you want to save the details of the export operation. you think you will need to do the same operation over and over again, check the Save export steps box and close the dialog.
The following Excel file is displayed. 'opens.
Now suppose you want to export data to a text file, in the External Data tab, click on the text file.
Specify the export options and click Ok. You will see the Encode dialog box, in which we want to export the data into the default encoding.
Select the first option and click Ok.
On this wizard screen, Access usually asks you if you want to save the details of the export operation. If you think you will need to perform the same operation over and over again, check the Save export steps box and close the dialog box.
You will now see that the text file is open.
Likewise, you can explore other options as well. Thus, it is highly recommended to also play with other import-export features.