Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
exporting access table excel

Forum home » Delegate support and help forum » Microsoft Access Training and help » Exporting access table to excel

Exporting access table to excel

ResolvedVersion Standard

Helen has attended:
Access Introduction course
Dreamweaver 8 Introduction course

Exporting access table to excel

Overview of exporting access table to excel?

RE: Exporting access table to excel

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.

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

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.09 secs.