O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Open the Access database from which you want to export an object.

  2. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required