Figure 8.6 The Export Text Wizard.
- The next screen (shown in Figure 8.7) lets you choose which character you want
as your delimiter. By default, it is the comma. Also by default, the text identifier is
the quotation mark. Make sure that these options are selected and click Next.
Figure 8.7 Choose your delimiter.
- The final pane of the Wizard (see Figure 8.8) is the file location. Enter the path
where you want to save this file and then click Finish. Barring any unforeseen
problems, your file should be created in the directory you specified.
Figure 8.8 Choosing the path and filename.
- You should now have a comma-delimited text file of the data from your query. To
double check, navigate to the directory where you have saved the file. Double-
click the filename and the file should open. You should see something similar to
Figure 8.9.