Access/Excel - differing versions

Resolved · Low Priority · Version Standard

Alexis has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Alexis [2 posts] (2008 Feb 12 Tue, 09:54) Reply

Would any data be compromised if the excel version used to link to an access database was a later version (eg Excel 2007 linking to Access 2003) ?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
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
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access/Excel - differing versions

by - trainer Pete platinum contributer [816 posts] (2008 Feb 14 Thu, 09:18) Reply

Hi Alexis, Thank you for your post, In answer to your question I cannot see any reason for the data to be compromised as Excel can accept input data from a wide range of input data sources, using the Data - Import External Data operation will show you. I hope that helps best regards Pete

· MS Access and Database Normalisation
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Tips for designing databases in Microsoft Access
· Microsoft Access as a Business's Database Management System
· How Reorganising Your Data Can Take Your Business to the Next Level

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

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips

Rate this page: