Databases make our lives easier by keeping insane amounts of data readily accessible and in one central repository of information. But, another thing that you can do for example if you’re using Microsoft Access is export data to other applications, like Excel, automatically so that you can do other tasks. The chance to be able to transfer data with a couple of clicks saves time and effort. Could you imagine having to reenter all that information in another program manually -The thought is scary enough. In this tutorial, I will show you how easy and fast you can export data from Access to Excel.
- First, make sure the Access database with the table containing the specific data that you want to export is open. Next, go to External Data>Export>Excel to select Excel as the file format where you want to export the data to.
- Next, the “Export – Excel Spreadsheet” pop up window box will appear. In here, enter the destination file and its format. Also click on both “Export data with formatting and layout” and “Open the destination file after the export operation is complete,” and click OK.
- Finally, you will see the newly exported data opened in an Excel spreadsheet.
That’s it! Now that was as easy as they come.