Adding Excel Data to an Access Database
If you want to use a large or complex Excel worksheet in an Access database, you don’t have to reenter the data in order to use it in Access. You can simply import the data into Access and use it as you’d use any other Access table. When you import the data, you’re creating a copy of the Excel worksheet data. The imported data is independent of the original Excel workbook file, so any changes you make to the data in Access won’t change the information in the Excel file.
Get the Excel Data
On the External Data tab in Access, with the database you want to use open, click the Import Excel Spreadsheet button.
Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
