- To open the Import Job Data from Application File (frmImportAppData) form, select the
“Import Data from App Files” option on the main menu and click the button to its left
(see Figure 10.10). The Job Data from Application File form is shown in its initial state in
Figure 10.18.
FIGURE 10.18
A form for importing data from legacy database and spreadsheet application files.- Click the Source File button to select a file of the type selected in the “Import File Type”
option group from a File Picker dialog, as shown in Figure 10.19. - As with text files, click the “Inspect New Jobs from App File” button to import data from
the selected file to a temporary table. The code sets that table as the source object of the
Jobs to Inspect subform, so you can see the new records before appending them to the
tblJobs table, as shown in Figure 10.20.
Working with External Data 10