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:
Open the Access database from which you want to export the data in a table.
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 ...
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.
