Microsoft Access: Export Data From Access To Excel, PDF or Text File

Microsoft Access 2010 is brilliant when it comes to exporting data to other applications offering many file formats…

Exporting data from Microsoft Access 2010 & 2007 is even easier than previous versions as it firstly provides an easy to view Ribbon Bar (External Data tab) displaying clear icons for different file formats and secondly being able to save your export actions for re-use.

I personally like the ability to now export to a PDF file which is also mentioned in this video tutorial as well as easily setup a connection to SharePoint services for publishing over either a network or the internet.

Emailing (as attachments) is a breeze too with a single click of a button locating your default email editor. If your have to export data to an unusual file or system, you can always investigate the ODBC Database option (found  under the More drop-down icon).

Finally, this video tutorial clearly highlights working the relationship between Microsoft Access and Microsoft Excel (which the majoirty will have available) taking advantage of the rich set of tools Excel provides.

I welcome your comments below – perhaps you may know of a shortcut to export data in Microsoft Access!


This entry was posted in MS Access, Utilities and tagged , , , . Bookmark the permalink.

4 Responses to Microsoft Access: Export Data From Access To Excel, PDF or Text File

  1. I am not positive the place you’re getting your information, but good topic. I needs to spend a while learning much more or working out more. Thank you for magnificent information I was looking for this info for my mission.

  2. Kim says:

    Fine information! I have been seeking something such as this for quite a while now. Thanks!

  3. Ben Beitler says:

    I use this veideo tutorial for my students as a resource and reminder in my Access database courses.

  4. C SIMMS says:

    Excellent video really helped me, thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.