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 Text File

You can export data from an Access table, a select query, or a crosstab query to a text file in one of two formats: delimited or fixed-width. You might find this procedure particularly useful for copying data from an Access table to a text editor or for uploading the data to a host computer.

To export the data from an Access table, a select query, or a crosstab query to a text file, do the following:

  1. Open the Access database from which you want to export the data in a table.

  2. Choose the table or query you want to export in the Navigation pane, and then click the Text File command in the Export group on the External Data tab. Access opens the Export – Text File dialog box. Click Browse, select the folder, and enter the name ...

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