Microsoft Access is an efficient program for creating and maintaining databases. You can use Excel spreadsheets to manipulate and assess the data that is kept in an Access table. Microsoft has made it simple for the Office applications to collaborate with each other to do various things. Exporting your data from Microsoft Access to be analyzed in Excel takes only a few minutes.
Open the database that contains the data you want to export in Access. Click on "File," then "Open" if you are using Access 2003 or earlier. Click on the "Office" button and then "Open" in Access 2007.
Choose what you want to export. You can open the table to export certain rows of data or export the entire table. To export just some of the data in the table, double-click the table to open it and then highlight the rows you want. To export the entire table, click it once in the Objects window.
Export the data to Excel. Click on "File," then "Export" if you are using Microsoft Access 2003 or earlier. The "Export" dialog box appears. Click the drop-down box next to "Save as type." Choose one of the Excel formats (depending on your version of Excel). Click the check box next to "Save formatted." Click "Save Selection" if you selected certain rows within the table. Click "Export All" if you want to export the entire table. For Access 2007, click on the "External Data" tab in the ribbon. Click "Excel" under the "Export" section. Follow the wizard to export the data you want to an Excel file.
- It is possible to just copy the data from an Access data table and paste it into Excel for a simple way to move the data over. Highlight all of the data in the table. Right-click anywhere in the table and click "Copy." Open up Excel, right-click in the worksheet and click "Paste." The data is copied over in the same format as it was in the Access table.
Tiesha Whatley has been writing for over 10 years. She has been published in "Marie Claire," "Ebony" and "Modern Bride" magazines. She holds a Bachelor of Science in English from the University of Alabama at Birmingham and has been working in the wedding planning industry for over 13 years.
black database image by .shock from Fotolia.com