- To open the “Export Job Data to Text File form (frmExportTextData), select the “Export
Data to Text Files” option on the main menu and click the button to its left. This form lets
you export a range of records filtered by date to either a comma-delimited or fixed-width
text file. - After you select the From Date and To Date, either by typing them in or using the date
selector pop-up, click the “Inspect New Jobs to Export” button to show the jobs in
the selected date range in the Jobs to Inspect (fsubNewJobs) subform, as shown in
Figure 10.16. - If you don’t want to go ahead with the export, use the “Clear Jobs to Export” button to
clear the selected jobs. - To proceed with the export, use the “Export Jobs to Text File” button to run code using
the TransferTextmethod to export the selected date range of jobs to a text file of the
type selected in the “Export Text Type” option group. Figure 10.17 shows an exported
comma-delimited file opened in Excel (which is the default application for .csv files).
FIGURE 10.16
Inspecting jobs in a given date range to export to a text file.Working with External Data 10