Export a datasheet to a delimited or fixed-width text file

Export a datasheet to a delimited or fixed-width text file

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

  2. In the Save As Type box, click Text Files (*.txt;*.csv;*.tab;*.asc).

  3. Click the arrow to the right of the Save In box, and select the drive or folder to export to.

  4. In the File Name box, enter the file name, and then click Save All.

    Microsoft Access starts the Export Text Wizard.

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