exporting information

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

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

Exporting information

resolvedResolved · 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


 

Access tip:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips


Server loaded in 0.11 secs.