Exporting to a Spreadsheet or to a dBASE File
Use the following procedure to export data from a table, a select query, or a crosstab query to a spreadsheet (Microsoft Excel 2010) or to a foreign database (dBASE) file:
Open the Access database from which you want to export an object.
Select the table or query you want to export in the Navigation pane. In the Export group on the External Data tab, click Excel, or click More and then click dBase File. Access opens the Export – Excel Spreadsheet or Export – dBase File dialog box. Click Browse, and select the file type, folder, and name of the file to which you want to export the selected object. After you make these selections, click Save. You can also enter the path and file name directly in the File ...
Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
