How to Convert Excel Documents to Microsoft Access.

How to Convert Excel Documents to Microsoft Access.

     1. Open Microsoft Access on your Computer.

2   2.  Click the “External Data” Tab and the click “excel” to import the Excel document into your Database.

1    3. Click “Browse” to select the Excel file you want to Import. 

2    4.  Click “Import the source data into a new table in the current database” to create a new table using the data imported from the Excel. You may also click “Append a copy of the record to the table” if you want to insert the Excel data into an existing table.

3    5. Click Ok

1    6.   Import Spreadsheet Wizard window pops up on your screen.

     7.  Click “First row Contains column headings” and click “Next”

1  8.  Select each field and change Field name, Data type, Indexed as per need. You also skip the field by clicking “Do not import field”.  

1    9.   Click “Next” to allow Microsoft Access to add a “Primary Key” which is Unique value

2   10. Click “Choose my own Primary Key” and select any field. You can also select “Let access add primary key” or “no Primary key”.

   

       11.  Click “Next” to Import the data from the excel File.

       12. Enter Table name and Click “Finish”.

1  13  Click  “Close” and you will see Excel Table imported into  Microsoft Access.