Exporting access table to excel

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

Resolved · Low Priority · Version Standard

Helen has attended:
Access Introduction course

by - delegate Helen [1 post] (2008 Mar 10 Mon, 17:13) Reply

Overview of exporting access table to excel?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 20 Mon + 21 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 14 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Exporting access table to excel

by - trainer Pete platinum contributer [799 posts] (2008 Mar 19 Wed, 12:53) Reply

Hi Helen,
Thank you for the post, Welcome to the forum,
In answer to your question: To export a table to Excel; Select the table in Database window, then from the menu toolbar select File> Export and in the dialog box, choose Save As type and select Excel 97 - 2000, give a name to the new workbook and click Export. The New Workbook will be created in the folder that you have chosen.
I hope that helps, best regards Pete.

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Take an Access Course to Learn About Relational Databases
· Microsoft Access Training Unleashes the Power of the Pivot Table
· The Benefits of Certified Microsoft Training in Access
· Reasons to Consider Microsoft Access Training

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

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips