Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking to external data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking to external data
Resolved · Medium Priority · Version 2003
Reply Mon 24 Nov 2008, 16:38Delegate Luigi said...
Luigi has attended:
Access Introduction course
Access Intermediate course
Linking to external data
Can you link to an external excel file? If so, how?
For upcoming training course dates see: Pricing & availability
RE: Linking to external data
Hi Luigi
The simple answer is Yes. To link a Access to an Excel spreadsheet do the following:
NB You need to make sure that the Worksheet you are linking to has the Column Headings in Row 1.
1. In the Access database Select File / Get External Data / Link tables
2. In the Link dialog box change the File Type to Microsoft Excel and then locate the required workbook
3. Click Link
4. In the Link Spreadsheet Wizard select the required worksheet. Click Next.
5. Tick First Row Contains Column Headings.Click Next.
6. Change the new table's name if required. Click Finish.
Your new table appears in Access with the link symbol and the Excel icon ready to be used.
Hope this helps
Carlos
|