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

exporting access data into

Forum home » Delegate support and help forum » Microsoft Access Training and help » Exporting Access data into Excel

Exporting Access data into Excel

ResolvedVersion 2000

Marianne has attended:
Access Introduction course
Access Intermediate course

Exporting Access data into Excel

Can I export pieces of information extracted from Access into Excel rather than complete queries/reports?

RE: Exporting Access data into Excel

Hello Marianne,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Exporting Access data into Excel.

To export data to Excel quickly, simply use the TOOLS > OFFICE LINKS > ANALYSE WITH EXCEL option.

This will take the current selected table or data and send it directly to Excel.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.