Importing queries from 2003

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

Resolved · Medium Priority · Version 2007

3 posts

ReplyMon 8 Jun 2009, 14:51Delegate Alan said...

Alan has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course

Importing queries from 2003

Can I import existing queries from 2003 when I upgrade from 2003 to 2007?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

870 posts

ReplyTue 9 Jun 2009, 06:46Trainer Rajeev said...

RE: Importing queries from 2003

Dear Alan

Thank you for attending Access 2007 Intermediate course!! I hope you enjoyed the course and benefited from it.

Please remember that you can open an earlier version database in Access 2007 and then choose Office button and save it as 2007 version.

This will ensure all your database objects get saved as 2007 version.

If you want only specific queries to be imported into Access 2007 then you can choose the External Data Tab on the Ribbon. Then in the Import group you can choose the Access button and import the objects from the relevant database.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 15 Jun 2009: Automatically marked as resolved.

· Have You Ever Wanted To Create A Combo Control On An Access Form?
· Take an Access Course to Learn About Relational Databases
· Use Microsoft Access to manage your work/life balance
· How Reorganising Your Data Can Take Your Business to the Next Level
· When To Use Access, When To Use Excel

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