Access+importing+text+document

Home / software / microsoft access / Tutorials

> > > > > Click Close
 * Practical Learning: Importing a Text Document ||
 * 1) To start a new database, click File and click New
 * 2) Set the name to **Red Oak High School **
 * 3) Click Create
 * 4) On the Ribbon, click External Data
 * 5) In the Import & Link section, click Text File [[image:http://www.functionx.com/access/buttons/textfile1.gif width="67" height="22"]]
 * 6) In the Get External Data - Text File dialog box, click the Browse button
 * 7) Locate the resources that accompany these lessons and select it
 * 8) Click Students.txt and click Open
 * 9) On the dialog box, click OK
 * 10) On the first page of the Import Text Wizard, accept that the text be Delimited and click Next
 * 1) On the first page of the Import Text Wizard, accept that the text be Delimited and click Next
 * 1) In the second page, accept that the delimiter be set to Comma and check the box stating: First Row Contains Field Names
 * 1) Click Next
 * 2) Accept the defaults of the third page of the wizard and click Next
 * 3) Accept to contents of the fourth page of the wizard and click Next
 * 4) Accept to import to table **Students** and click Finish
 * 5) You receive a confirmation message when the table has been imported.
 * 1) In the Navigation Pane, double-click the Students table to open it
 * 2) Double-click ID, type **StudentID** and press Enter
 * 3) Save and close the Students table