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

exporting information

Forum home » Delegate support and help forum » Microsoft Access Training and help » Exporting information

Exporting information

ResolvedVersion 2007

Binta has attended:
Access Introduction course

Exporting information

How do you export information to another document? i.e. excel

RE: exporting information in Excel

Dear Binta

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

In 2007 it is straightforward to export or import data from other programs such as Excel.

Open the table or query you wish to export.
On the Ribbon choose the External data Tab
Under the Export Group choose the Excel icon
A dialog box will appear. If you want to see the result of your Export in Excel then choose the option Export data with formatting and layout and also open the destination file after the export operation is complete.

If you wanted to export it in an older version of Excel because you might want to share with people who don

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.