Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Linking Ms Office
|
|
|
Bookmark this page|
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. |
excel training course - Linking Ms Office
Resolved · Low Priority · Version Standard
Reply
Linking Ms Office
how do I link from Excel to Access?For upcoming training course dates see: Pricing & availability
RE: Linking Ms Office
From Access, you can use FILE > GET EXTERNAL DATA > Import.From Excel, you can use TOOLS > IMPORT EXTERNAL DATA > DATABASE QUERY. This requires some technical setup, which you should have covered on your course. If you require some additionl info, please let us know.
RE: Linking Ms Office
Hi Richard,Thank you for reply. My question was to create the live steam link between two applications so we don
RE: Linking Ms Office
Hi RezaSo to create a link from Excel to Access do the following:
In Access,
1. Click FILE > GET EXTERNAL DATA > Link tables
2. Locate the excel file you want to link to
3. Change the file ype to Excel
4. Select file, click Link
5. step through the link spreadsheet wizard
6. choose source
7. field headings
8. file name
You might want to consider creating a named range for the data you want to link to Access, unless all the headings are in the first row in the excel spreadsheet.
For the courseware, go to :
http://www.microsofttraining.net/download/delegate/onsite/excel_advan_2002_113795.zip
to download your manual.
Richard
|
 |
|
» Forum post: Excel |
Where is the Format Table in the Excel 2003?
