ms access course - Linking excel

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

ms access course - Linking excel

Linking excel

Julia has attended:
Access Introduction course

by - delegate Julia [1 post] (2008 Jan 23 Wed, 16:26) Reply

How to link excel need this again

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Linking excel

by - trainer Carlos gold contributer [479 posts] (2008 Jan 28 Mon, 12:05) Edited on 2008 Jan 28 Mon, 12:19 Reply

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

ms access course - Linking excel

Related articles

Access tip:

Label printing