Microsoft Access 2010 Bible

Chapter 17: Importing and Exporting Data

619

4,Peacock,Margaret,5/3/15 0:00:00,4000

5,Buchanan,Steven,10/17/15 0:00:00,5000

6,Suyama,Michael,10/17/15 0:00:00,1000

7,King,Robert,1/2/14 0:00:00,1056

8,Callahan,Laura,3/5/14 0:00:00,1056

9,Dodsworth,Joeseph,11/15/14 0:00:00,1056

Notice that the file has nine records (rows of text) and five fields. A comma separates each field. In

this example, text fields are not delimited with double quotation marks. Notice also that the rows

are different lengths because of the variable data within each row.

To import a delimited text file named ImportDelim.txt, follow these steps:

1. Open the Chapter17_1.accdb database.


2. Select the External Data tab.


3. Click Text File in the Import group.


4. Find the ImportDelim.txt file using the Browse button, select it, and click OK.

The first screen of the Import Text Wizard (shown in Figure 17.11) appears.

FIGURE 17.11

The first screen of the Import Text Wizard

The Import Text Wizard displays the data in the text file and lets you choose between
delimited or fixed-width.

5. Select Delimited and click Next.

The next screen of the Import Text Wizard (shown in Figure 17.12) appears.