Access.2007.VBA.Bibl..

FIGURE 10.8

The Manage Data Tasks dialog, where you can select a saved import or export specification.

Sometimes the wizard doesn’t recognize that the first line of a text file contains the field

names. In that case, you need to give the fields appropriate names, and then delete the

first row, with the field names as data, after the import is finished (you will probably get some Type

Conversion errors in the Import Errors table for that line). Figure 10.9 shows the table of imported

jobs data, and the Import Errors table with errors on the first row containing the field names.

FIGURE 10.9

A table of imported text data, with field names in the first data row, and an Import Errors table.

NOTENOTE

Working with External Data 10