Exporting Tables, Queries and Reports [00:00:00.00] [MUSIC PLAYING] [00:00:05.80] PROFESSOR: In this session, I'm going to demonstrate how to export data from Access into Excel. A lot of times in a business scenario and such, you can run reports, you can run queries, or you want to export data from your database, and put it into an Excel spreadsheet, and then work with the data, and create charts, or use it for other functions from within Excel. So you can do it from the tables or you can do it from a query. You can export the data from a query or you can export the data from a report. [00:00:38.84] So let's see first from a table, exporting data from a table into Excel. We click here on that Contact table, which looks like this at this point. We right click on it, and there's this option for export. And you can choose to export it in any of those formats. You could also go under External Data here and choose to export from up here into Excel. [00:01:03.70] So right click, Export Excel, and then choose the location where you want to save this, and how you want the formatting of the layout, if you prefer. Click OK, and you can choose to save those steps. Those steps, by the way, will show up on the external data here under the Saved Exports. Click Close. Now, that data should be in Excel. [00:01:30.70] If I go here to my File Manager, now this, I have a file here called Contracts. I open this file, and now I can work with this any way that I prefer from Excel. And, of course, they are two separate entities at this point. So if you change something in Excel, it's not going to update it in Microsoft Access. So that's how you export data from a table. [00:01:56.77] The process is exactly the same for exporting the data from a query or from a report. So for the query, we run the query first. So in this case, I have a query here, the date, parameter, and all that type of stuff. So this is my data. And now at this point, I can simply right click, choose Export Excel, choose where I want to store it, give it a name, press Save, and Finish. [00:02:28.78] And we can do this for the contacts as well by customer. Same thing with the report. This is our report. Right click, choose Export, choose Excel Format. Choose where you want to store it. Now, this contact is by customer report. Click OK. [00:02:53.02] And now, if I go to my folder where I exported this, the data is there. And this was the query that I ran earlier for the dates from January 1 to June 30 from the query. So that's how exporting data works from Microsoft Access to another system, such as Microsoft Excel. It's a commonly used feature in business. [00:03:21.72] [MUSIC PLAYING]