• Select File, Get External Data, Import... from the menu bar
    • In the Import screen, browse to and select the file to import
    • Follow the instructions in the Import Text Wizard. The screens in the wizard vary based on the file format. The example below is for CSV format. If you are importing another file format, be sure to carefully read each screen in the wizard and make the appropriate selections.

      1. In the Choose the delimiter that separates your fields frame, select Comma. In the qualifier drop-down menu select the double quotes ("). Mark the First Row Contains Field Names checkbox if the file contains headers in the first row. Click Next.
      2. In the Where would you like to store your data frame, select In a New Table. Click Next.
      3. Select each column in the bottom of the screen and enter a field name and data type in the top of the screen. If you marked the First Row Contains Field Names checkbox in step a, the field names are automatically populated. Click Next.
      4. Determine what to use for the primary key:

        • Let Access add primary key. Select this to have Access add a column for the primary key and automatically populate it for each record.
        • Choose my own primary key. Select this when you have a field that contains a unique value for each record.
        • No primary key. Select this if you do not want a primary key. Click Next.

        • Enter the name for the table in the Import to Table field. Click Finish. These fields now appear as a table in the Access database.