Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training course - linking ms office

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Linking Ms Office

excel training course - Linking Ms Office

ResolvedVersion Standard

Reza has attended:
Excel Advanced course

Linking Ms Office

how do I link from Excel to Access?

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 Reza

So 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.

Richard

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.