Import Excel data to an Access database

  1. Make sure the Microsoft Excel data
    • is in list format
    • each column has a label in the first row and contains similar facts
    • there are no blank rows or columns within the list.
  2. Close the Excel workbook that contains the data you want to use in Microsoft Access.
  3. In Access, open the database where you want to copy the Excel data.
  4. On the Access File menu, point to Get External Data, and then click Import.
  5. In the Import dialog box, click Microsoft Excel in the Files of type box.
  6. In the Look in list, locate the file you want to import, and then double-click the file.
  7. Follow the directions in the Import Spreadsheet Wizard.

    For more information about this wizard and Access, click Display Help after the wizard is finished.
 

Published: 13-January-2004
Last edited: 11-Jun-2005 23:49