98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Exporting information
Exporting information
Resolved · Low Priority · Version 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
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. |
Access tip:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |