Microsoft Office Tutorials and References
In Depth Information
Adding Data to a Table by Importing a Text File
Before Belmont Landscapes decided to store data using Access, Sarah managed the
company’s customer data in a different system. She exported that data into a text fi le and
now asks you to import it into the new Customer table. You can import the data
contained in this text fi le to add the remaining records to the Customer table.
Adding Data to a Table by Importing a Text File
There are many ways to import data into an Access database. So far, you’ve learned how
to add data to an Access table by importing an Excel spreadsheet, and you’ve created a
new table by importing the structure of an existing table. You can also import data
contained in text fi les.
To complete the entry of records in the Customer table, you’ll import the data
contained in Sarah’s text fi le. The fi le is named “Customer” and is located in the
Access1\Tutorial folder provided with your Data Files.
To import the data contained in the Customer text file:
1. Click the External Data tab on the Ribbon.
2. In the Import & Link group, click the Text File button. The Get External Data -
Text File dialog box opens. This dialog box is similar to the one you used earlier
when importing the Excel spreadsheet and the Access table structure.
3. Click the Browse button. The File Open dialog box opens.
4. Navigate to the Access1\Tutorial folder, where your starting Data Files are
stored, and then double-click the Customer file. You return to the dialog box.
5. Click the Append a copy of the records to the table option button. The box
to the right of this option becomes active. Next, you need to select the table to
which you want to add the data.
6. Click the arrow on the box, and then click Customer .
7. Click the OK button. The first Import Text Wizard dialog box opens. The dialog
box indicates that the data to be imported is in a delimited format. A delimited
text file is one in which fields of data are separated by a character such as a
comma or a tab. In this case, the dialog box shows that data is separated by the
comma character in the text file.
8. Make sure the Delimited option button is selected in the dialog box, and then
click the Next button. The second Import Text Wizard dialog box opens. See
Figure 2-36.
Search JabSto ::




Custom Search