microsoft+access+course - linked tables
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page 		Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+course - Linked tables

Active questions (227)
Advanced/consultancy questions (17)
Today's questions
Unanswered questions (129)

See also: Hints and tips

Bookmark This PageBookmark this page

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.

microsoft+access+course - Linked tables

The UK's most regular instructor-led training courses.
Training information: microsoft+access+course · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

resolvedResolved · Low Priority · Version Standard

Linked tables

Martin has attended:
Access Advanced course

by - delegate Martin [4 posts] (2007 Aug 31 Fri, 12:58) replyReply

Can Access 2003 link to excel 2.1

Access VBA 2 day course
Version Date Location Places
available		 Book Next place rate:
Card Invoice
2003 2008 Dec 4 Thu + 5 Fri Southwark 3 book now £475 £495
2003 2009 Jan 8 Thu + 9 Fri Southwark 6 book now £450 £485
2003 2009 Feb 5 Thu + 6 Fri Southwark 8 book now £275 £399
2003 2009 Mar 5 Thu + 6 Fri Southwark 7 book now £345 £399
2003 2009 Apr 8 Wed + 9 Thu Southwark 8 book now £275 £399
2003 2009 May 7 Thu + 8 Fri Southwark 8 book now £275 £399
Full Schedule: See all 12 Access VBA course dates.
Bookings currently available until 5th November 2009.

RE: Linked tables

by - trainer David gold contributer[418 posts] (2007 Sep 4 Tue, 10:07) replyReply

excel 2.1? are you sure this is the right version?

RE: Linked tables

by - delegate Martin [4 posts] (2007 Sep 4 Tue, 10:14) replyReply

The data is derived from a web-site running an old version of Brio. The default output is excel 2.1, which I currently have to open and save into a later version for the database to read it.

RE: Linked tables

by - trainer David gold contributer[418 posts] (2007 Sep 4 Tue, 16:11) replyReply

sorry, what is brio?

RE: Linked tables

by - delegate Martin [4 posts] (2007 Sep 4 Tue, 16:43) replyReply

Brio is a reporting package similar to Crystal.

RE: Linked tables

by - trainer David gold contributer[418 posts] (2007 Sep 4 Tue, 19:56) replyReply

ok, have you tried opening excel 2.1 in excel and saving it as a later version?

RE: Linked tables

by - delegate Martin [4 posts] (2007 Sep 5 Wed, 08:38) replyReply

Pasted from my original question:

"The default output is excel 2.1, which I currently have to open and save into a later version for the database to read it."

I do not wish to open and save a file, I would like to link to it as exported from the web site.

RE: Linked tables

by - trainer David gold contributer[418 posts] (2007 Sep 6 Thu, 11:29) replyReply

Martin

I dont think it can, but we will keep checking.

regards

info

Related articles

· Microsoft Access Courses
· Three Myths About Microsoft Access
· Convert a Paper Trail to a DBMS
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips
Rate this page:
4.0/5 (3 votes cast)
Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office		 Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

 Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
 microsoft+access+training · access courses in london

Training Information

Training Articles
AddThis Social Bookmark Button What's this?
Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo Add to Diigo Add to Mr. Wong Add to Linkarena Add to Power Oldie Add to Folkd Add to Jumptags Add to Upchuckr Add to Simpy Add to StumbleUpon Add to Slashdot Add to Netscape Add to Furl Add to Spurl Add to Blinklist Add to Blogmarks Add to Technorati Add to Newsvine Add to Blinkbits Add to Ma.Gnolia Add to Smarking Add to Netvouz

© 2008 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions