RE: Linking excel
Hi Julia
If you have data on an Excel worksheet that is needed in an Access Database you import the Excel table.
However if the Excel sheet is constantly being updated, then you need to link the Excel table to the Access database. To do this :
NB Before doing this make sure the table being imported from Excel is correctly setup. (ie Row 1 must contain the Column headings / Field names)
1. Open the File Menu and select Get External Data. In the sub menu select Link Tables
2. The Link dialog box appears
3. Find the folder that contains the required Excel workbook
3. In the Files Of Type select Excel
4. Select the name of the Workbook to be linked
5. Click Link
6. The Link Spreadsheets Wizard appears. Go through to the finish and fix anything that is required.
7. When done click Finish
A new table appears in the database with the Excel Icon and the Link symbol. and will update as the workbook is updated
Hope this helps
Carlos
