Forum home » Delegate support and help forum » Microsoft Access Training and help » Exporting information
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Exporting information
Resolved · Low Priority · Version 2007
Reply Mon 22 Sep 2008, 16:32Delegate Binta said...
Binta has attended:
Access Introduction course
Exporting information
How do you export information to another document? i.e. excel
For upcoming training course dates see: Pricing & availability
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
|