Database Reference
In-Depth Information
Now let's populate the empty Employees table.
9
On the
External Data
tab, in the
Import & Link
group, click the
Tex t File
button to
start the
Get External Data
wizard.
TIP
Tex t files typically have a .txt extension. However, some programs save delimited
text files with a .csv or .tab extension. You will also occasionally find text files with an
.asc (for ASCII) extension. Some programs save fixed-width text files with a .prn (for
printer) extension, which Access doesn't recognize; you would need to change this
extension to one that Access does recognize. Access treats text files with all accept-
able extensions the same way.
10
Browse to the
Chapter10
practice file folder, click the
Employees
text file, and then
click
Open
.
11
Click
Append a copy of the records to the table
. Display the adjacent list, and click
Employees
. Then click
OK
, which starts the
Impor t Tex t
wizard and displays the
content of the selected delimited text file.
Each field is enclosed in quotation marks, and the fields are separated by commas.