Importing Files into Access or Database Software



Open Access and either open an existing database or create a new database. 

Click on the File menu, select Get External Data, and then select Import. 

Locate the folder where you saved the files in Step 1.  

In the Files of Type field, select Text Files ( *.txt; *.csv; *.tab; *.asc ). 

Select the text file you wish to import and click Import. 

Import Wizard Step 1: Choose Delimited format. 

Import Wizard Step 2: Choose Comma as your delimiter.  Check the First Row Contains Field Names box.  Choose     none as your text qualifier. 

Import Wizard Step 3:  Import to a New Table. 

Import Wizard Step 4: If you wish, add a primary key.  A primary key is a field which serves as a unique identifier for         each record. 

Import Wizard Step 5:  Name your table and click Finish. 

3. Your file is now imported to Access.  The new table will be saved to the database into which you imported.  If you have more than one file to import, repeat the above process for each file.  To save all your tables in one Access file, select New Table in Import Wizard Step 3 and give each table a unique name.