When importing from (or exporting to) dBASE or Paradox formats using the
TransferDatabasemethod, the DatabaseNameargument takes the path, not the
database name; the database name is set with the Sourceargument. The path must be set without a
final backslash, or else it will cause an error.- Use the “Clear Imported Jobs Data” button to clear the imported data without adding it
to tblJobs. - Use the “Save New Jobs to Table” button to append the imported jobs data to tblJobs.
Importing a Paradox file is quite similar; only the database type argument is different.
Figure 10.21 shows new jobs data imported from a Paradox 4 database.
FIGURE 10.21
Inspecting data imported from a Paradox database.Curiously, there isn’t an enum of named constants for the values used to set the DatabaseType
argument of the TransferDatabasemethod; you have to type in the values. Table 10.1 lists the
values you need to use for different versions of dBASE and Paradox.NOTENOTE
Working with External Data 10