Microsoft Office Tutorials and References
In Depth Information
Adding Data to a Table by Importing a Text File
Second Import Text Wizard dialog box
fields in the text
file are separated
preview of the data
This dialog box asks you to confirm the delimiter character that separates the
fields in the text file you’re importing. Access detects that the comma character is
used in the Customer text file and selects this option. The bottom area of the
dialog box provides a preview of the data you’re importing.
9. Make sure the Comma option button is selected, and then click the Next button.
The third, and final, Import Text Wizard dialog box opens. Notice that the Import
to Table box shows that the data will be imported into the Customer table.
10. Click the Finish button. A dialog box opens asking if you want to save the import
steps. You’ll only import the customer data once, so you can close the dialog box
without saving the import steps.
11. Click the Close button in the dialog box to close it without saving the import steps.
Oren asks you to open the Customer table in Datasheet view so he can see the results
of importing the text ﬁ le.
To view the Customer table datasheet:
1. Open the Navigation Pane, and then double-click Customer to open the Customer
table in Datasheet view. The Customer table contains a total of 40 records.
2. Close the Navigation Pane.