• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 8. Linking, Importing, and Expor... > Exporting Table Data as Text Files

Exporting Table Data as Text Files

Exporting a table involves a sequence of operations similar to importing a file with the same format. To export a table as a comma- or tab-delimited file that you can use as a merge file with a variety of word-processing applications, complete these steps:

Select the table you want to export in the Database window, and choose File, Export to open the Export Table ’Tablename’ To dialog.

Select Text Files (*.txt;*.csv;*.tab;*.asc) in the Save as Type drop-down list. Use the Save In drop-down list to select the drive and folder in which you want to store the exported file, type a name and extension for the exported file in the Filename text box, and then click Save to start the Text Export Wizard.


Using the Text Export Wizard, including its advanced options, is the same as using the Import Text Wizard described in the “Importing Text Files” section earlier in the chapter, except that the result is an external text file instead of an Access table. You save and reuse export specifications by the method described for import specs.

When exporting a text file, the Text Export Wizard doesn’t have a step to edit field names or select field data types; these options aren’t relevant when exporting data.

Follow the procedures as though you were importing a text file. Figure 8.66 shows the Customers table exported as a tab-separated text file from the Northwind.mdb database and displayed in Windows Notepad.

Figure 8.66. The two highlighted records of tab-separated text file demonstrates the problem that arises when fields contain newline pairs to, for instance, create multiline display of address data.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint