You are currently offline, waiting for your internet to reconnect

How to Import Microsoft Excel File Into Microsoft Access

This article was previously published under Q141228
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SUMMARY
This article explains how to import a Microsoft Excel file into MicrosoftAccess version 2.0 or 7.0. Microsoft Access can import files from MicrosoftExcel version 2.0 through version 7.0. However, Microsoft Access cannotimport Microsoft Excel 4.0 workbooks (.xlw). This article assumes that theMicrosoft Excel file is using standard database formatting. That is:

   - The columns in the list are the fields in the database.   - The column labels in the list are the field names in the database.   - Each row in the list is a record in the database.				
MORE INFORMATION

To import a Microsoft Excel file in Microsoft Access 2.0

  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 2.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Import. From the Import dialog box, choose the appropriate version of Microsoft Excel that you are importing and click the OK button. Microsoft Excel 7.0 files are not on this list. If you are importing a version 7.0 file, choose the Microsoft Excel 5.0 option.
At this point options such as whether to append to an existing table orcreate a new table may be selected.

To import a Microsoft Excel file in Microsoft Access 7.0

  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 7.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Get External Data and then click Import.
  4. From the import dialog box, choose Microsoft Excel (*.xls) for the Files Of Type option.

    This will display only the Microsoft Excel files.
  5. Find the desired file and click the Import button.
The Import Spreadsheet Wizard appears and allows you to choose optionsspecific to the file.
REFERENCES
For more information about Import Microsoft Excel spreadsheets intoMicrosoft Access, choose the Search button in Microsoft Access Help andtype:

   Import				
3.00 4.00 95 bring open merge combine XL
Properties

Article ID: 141228 - Last Review: 08/17/2005 18:18:13 - Revision: 1.3

  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 4.0c
  • Microsoft Excel 3.0a
  • Microsoft Excel 2.10d
  • Microsoft Excel 2.1 Standard Edition
  • Microsoft Excel 2.01
  • Microsoft Excel 2.0 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • KB141228
Feedback