Export a datasheet to a delimited or fixed-width text file
- In the Database window, click the name of the table, query, view, or stored procedure you want to export, and then on the File menu, click Export.
- In the Save As Type box, click Text Files (*.txt;*.csv;*.tab;*.asc).
- Click the arrow to the right of the Save In box, and select the drive or folder to export to.
- In the File Name box, enter the file name, and then click Save All.
Microsoft Access starts the Export Text Wizard.
- Follow the directions in the dialog boxes. Click Advanced to create or use an import/export specification.
Note To include the datasheet's font and other formatting elements that aren't included in a text file, you can save all or a selection of a datasheet as a Rich Text Format file. For information, click .