1-866-245-5224 sales@keystonelearning.com

Access 2007: Import Your Excel Spreadsheet into Access

Access 2007: Import Your Excel Spreadsheet into Access

When creating a database, it’s fairly common that some of your data is already stored in a Excel spreadsheet. With a simple Import, you can quickly bring information stored in an Excel worksheet into an Access table.

And, the beauty of it is that Access has a wizard built for just such an occasion taking much of the work out of it for you.

Create a new table by importing or linking to external data

     
  1. Open any database
     
  2.  
  3. Choose the Excel command in the Import group on the External Data tab
     

Figure 21. Import from Excel -  Choose File Name & Import Type

    3.       Choose a File Name

    4.       Choose “Import the source data into a new table in the current database

    5.       Click OK

 

Figure 22. Import from Excel -  Choose Worksheet or Named Ranges

 

    6.       Choose “Show WorksheetsorShow Names Ranges

    7.       Click Next

 

Figure 23. Import from Excel - First Row Contains Column Headings?

 

    8.       If applicable, check “First Row Contains Column Headings

    9.       Click Next

 

Figure 24. Import from Excel - Verify Field Data Types

 

    10.   Verify data type of each imported field

    11.   Click Next

 

Figure 25. Import from Excel - Choose a Primary Key

 

    12.   Choose a Primary Key option

    13.   Click Next

 

Figure 26. Import from Excel - Enter a Table Name

 

    14.   Enter a Table Name

    15.   Click Finish

 

Figure 27. Import from Excel - Save Import Steps?

    16.   Click Close