How to Create a Spreadsheet Using Access
- 1). Open Access 2010. Click the "File" tab, and select "Open." Browse your files, and locate an existing Access database. Click the database, and select the "Open" button. The database opens.
- 2). Double-click a table from the Navigation Pane. The table opens in the table datasheet view. Click "External Tools" on the ribbon, and select "Export" in the "Export" group.
- 3). Review the file path and the Excel file format. Click "OK." The file is downloaded to the file path.
- 4). Open the spreadsheet by opening Excel 2010. Click the "File" tab, and select "Open." Browse your files, and locate the spreadsheet. Click the spreadsheet, and select the "Open" button. The spreadsheet opens.
Source...