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