Excel import

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

Resolved · Low Priority · Version Standard

Excel import

Dominique has attended:
Access Introduction course
Access Intermediate course

by - delegate Dominique [2 posts] (2008 Mar 10 Mon, 17:12) Reply

how do I export Access table to Excel

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£190	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: excel import

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

Hi Dominique, Thank you for the post, 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.

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Reasons to Consider Microsoft Access Training

Please browse our web site to find out more about
access vba 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