After selecting Use Export Wizard from the Select Format list, press the Start button and the Export Wizard (figure 1) will begin to guide you through the process.

image100
(figure 1)

On this screen, select the dBASE (*.dbf) option and press Next to continue.



You will now be prompted to specify the origin of the file data character set, ANSI (Windows), or ASCII (DOS).

Also, decide if you want to Include column titles, add a blank row after field names as a separator, and treat Blank values (NULL) as zeroes.

image101
(figure 2)

After making your selections, press Next to continue.



In this dialog (figure 3), you can select or un-select columns by checking or unchecking the box next to their names; alter field Title information such as the Caption, Alignment, Background, and Font attributes; and set Data properties such as field Alignment, Background, and Font attributes.

NOTE:
The Width value is used only for Text exporting where Fixed Width is specified.

image102
(figure 3)

After making your selections, press Next to continue.



During the export process, the "Specifications..." button is available to save your export options or to unload preexisting options from a previous data export. The specification file will store your export options for type, source file, fields, settings and mode.

SpecificationFile


The specification files can be loaded for the current data export, saved for future exports (using both the user interface or the GATEWAY command), or deleted. The specification files are stored in the current database directory with the .RGW file extension.

ImportSpec




The final screen (figure 4), allows you to specify the export file name; determine if you want the records broken up into separate files based on the quantity of records in each file; and any optional Action after exporting such as opening the file based on the file association of the current machine.

NOTE:
The Records per each file option only works with the following output formats:

·MS Excel Spreadsheet (*.xls)  
·MS Excel Workbook (*.xls)  
·SYLK Symbolic Link (*.slk)  
·DIF Data Interchange Format (*.dif)  
·Lotus 1-2-3 (*.wk1)  
·QuattroPro (*.wq1)  
·LDAP Data Interchange Format (*.ldif)  

To use this feature, check the box next to the Records per each file caption, and type the numeric value of records per file in the field to the right.

image103
(figure 4)

Make your selection, and then press Execute to export the data accordingly.