importing data

In Access, you can either create a link to the spreadsheet, or import it as a table. If you link to it, then updates made in either location will happen in both. Importing it means the data will only change in the location you're working on.

From Access, go to File: Get External Data: Import/Link. You will have to change the File Type drop down to Excel, then select the Excel File. There's a wizard that will walk you through the process, allowing you to identify if there are headers, etc, and to select the records you want to import.