Exporting a List of Data Values in a Recordset

You are able to export a list of data values in a recordset to an external comma-separated value (.CSV) file.

To export a list of data values in a recordset:

  1. In the Navigation pane, click Data.

The Data window opens.

  1. In the Layouts Summary pane, select a layout.
  2. In the Details pane, click the Recordsets tab.
  3. In the Recordset tab, right-click on a recordset and select Edit.

The Recordset Editor opens.

  1. Click the Export button.

The Export Recordset dialog opens.

  1. Click the Browse button to select the directory where you want to export the values.
  2. In the Select Export File dialog, enter the file name with one of the following extensions:
  3. CVS
  4. XLS
  5. XLSX
  6. Click Save.
  7. If you selected to export your data as a CSV file, select one of the following Column Delimiter options:
  8. Comma
  9. Tab
  10. Semicolon
  11. Space
  12. Other
  13. If you want to include headers, select the Include Headers option.
  14. Select a Text Qualifier from the drop-down list:
  15. "
  16. '
  17. <none>
  18. From the Text Encoding drop-down list, select one of the following options:
  19. Western European (Windows)
  20. Unicode

  21. From the Sheet Name drop-down list, select a Microsoft Excel sheet name.

  22. Click OK.

    Your values are exported to a .CSV file and saved in the selected directory.

 

Related Topics Link IconRelated Topics