To Documents

Importing a Textfile into Access

• Here are the steps for importing a textfile into a 2002-2003 Access file.
   
  
  1. Create a comma delimited file where the first line contains the column names, for example, persons.txt.
      
  2. Open Access. In the classroom lab: Start >> Microsoft Access >> Microsoft Access 2007.
      
  3. Select New Blank Database. Enter persons.mdb in the Name: textbox. Click Create.
      
  4. Close the table Table1.
      
  5. Select the External Data Tab in the Main mMenu >> Text File.
      
  6. Verify that the radio button Import the source data into a new table in the current database is selected, browse to find the persons.txt file. Click OK.
      
  7. Verify that the Delimited radio button is selected. Click Next.
      
  8. Check the check box First Row Contains Field Names. Click Next.
      
  9. Click Next.
      
  10. Check the radio button No primary key or Choose my own primary key
       
  11. Verify that Persons is entered in the Import to Table textbox. Click Finish.
       
  12. Click Close. The Persons table is created.
       
  13. Open the Persons table or close Access.