Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking Excel to Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Linking Excel to Access

Resolved · Low Priority · Version 2007

Reply Mon 23 Aug 2010, 16:12Delegate Deborah said...

Deborah has attended:
Access Intermediate course
Access Introduction course
Excel Advanced course
Excel Intermediate course
Excel Advanced course

Linking Excel to Access

Is there any value to linking an entire workbook vs a single spreadsheet?

For upcoming training course dates see: Pricing & availability

Reply Tue 24 Aug 2010, 18:20Trainer Anthony said...

RE: Linking Excel to Access

Hi Deborah, thanks for your query. Depends what you've got in the workbook really. Remember that Access chops up each worksheet in the workbook into a separate table in Access, so you'd have to go through the Link Tables process for each worksheet in the workbook to link the whole thing into Access.

Hope this helps,

Anthony

Reply Wed 25 Aug 2010, 11:16Delegate Deborah said...

RE: Linking Excel to Access

Thank you very much, Anthony (for everything!).

I am looking forward to utilizing "Link Tables" when I rebuild our pesky little database from scratch.

Access articles

· Up The Professionalism Of Access Files Thanks To Digital Signatures
· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· Why Do I Need To Use Access?
· How To Sort And Filter A Table In Access 2010
· So what's new in Access 2007?

Please browse our web site to find out more about
access/courses and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips