- 1). Close the Excel spreadsheet that needs to be linked to Access. Open the Access database.
- 2). Click the "External Data" tab and select "Excel" under the "Import" tab for Access 2007. Click the "File" menu, select "Get External Data" and click "Import" for Access 2002.
- 3). Click "Browse," then browse to the location of the spreadsheet and click "OK" to select the file. Choose the "Link to the data source" option in the import wizard and click "OK." Follow the link spreadsheet wizard to complete the import.
- 4). Open the table that you imported in Access. The spreadsheet data will now be linked in Access as an Access table.
- 5). Perform analysis in Access with the data from the Excel spreadsheet. Note that the linked table in Access cannot be modified.
- 6). Go to the Excel spreadsheet to make any changes to the data and save the spreadsheet. The changes will be reflected in the linked Access table.
- Advertisement -
- Advertisement -