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

Access 2003: Import Your Excel Spreadsheet into Access

Access 2003: 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 File: Get External Data: Import from the Menu bar
     

Figure 15. Import - Choose File & Import Type

   3.      Choose a File

   4.      Next to Files of type, click the drop-down arrow and choose Microsoft Excel (*.xls)

   5.      Click Import

 

Figure 16. Import - Choose Worksheet or Named Ranges

 

   6.      Choose “Show WorksheetsorShow Names Ranges

   7.      Click Next

 

Figure 17. Import - First Row Contains Column Headings?

 

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

   9.   Click Next

 

Figure 18. Import from Excel - Verify Field Data Types

 

   10.  Verify data type of each imported field

   11.  Click Next

 

Figure 19. Import – Set Field Options

 

   12.   Click each column and set the field options

   13.   Click Next

 

Figure 20. Import - Set a Primary Key

 

   14.   Choose your primary key preference

   15.   Click Next

 

Figure 21. Import - Enter a Table Name

 

   16.   Enter a Table Name

   17.   Click Finish

 

Figure 22. Import Confirmation

18.   Click OK