Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.

Microsoft Corporation: Import or Link to Data in an Excel Workbook Addictive Tips: Access 2010: Import Worksheet From Excel 2010 Microsoft Corporation: Introduction to Importing and Exporting Data ...

Launch Excel and open the spreadsheet you wish to load into Access. Verify that the spreadsheet's column names match the Access table's field names.

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather ...