Supercharge your PowerPoint productivity with
Supercharge your PPT Productivity with PPTools - Click here to learn more.

Proud member of


Image Export converts PowerPoint slides to high-quality images.

PPT2HTML exports HTML even from PowerPoint 2010 and 2013, gives you full control of PowerPoint HTML output, helps meet Section 508 accessibility requirements

Merge Excel data into PowerPoint presentations to create certificates, awards presentations, personalized presentations and more

Resize your presentations quickly and without distortion

Language Selector switches the text in your presentation from one language to another

FixLinks prevents broken links when you distribute PowerPoint presentations

Shape Styles brings styles to PowerPoint. Apply complex formatting with a single click.

What this section is about

A quick note to non-programmers

If you arrived at this page from a web search, you may be looking for a way to import data into PowerPoint. Before reading on, you should understand that this part of the PowerPoint FAQ site is devoted to VBA and VB programming.

If you're not a programmer, the information that follows is probably not what you're after. In fact, if you're not a programmer it won't make a lick of sense. Run away while you still have your sanity.

On with the show ...

Sometimes the data you want to use in your PowerPoint presentations is available but not easily accessible from PowerPoint.

The data you need might live an an Excel file or Access database or even a text file, but PowerPoint can't easily import data from these sources, at least not in any simple, direct and immediately useful way.

In this section, we'll explore ways of importing data from external sources. While we'll demonstrate a a few relatively simple ways of displaying the information in PowerPoint, mostly we'll be using good old Debug.Print

The emphasis will be on getting the data rather than what you do with it. After all, what you do with it is up to you.


I'm not a database professional. In fact, I'll be writing some of these tutorials as I learn how to use the techniques demonstrated.

Luckily, I have the help (and generously donated sample code) of Microsoft Access MVP Naresh Nichani and PowerPoint MVP Brian Reilly. Their work will become the foundation for this series of tutorials.

If you have questions about how the code works, please post them on the PowerPoint Newsgroup

Did this solve your problem? If so, please consider supporting the PPT FAQ with a small PayPal donation.
Page copy protected against web site content infringement by Copyscape Contents © 1995 - 2022 Stephen Rindsberg, Rindsberg Photography, Inc. and members of the MS PowerPoint MVP team. You may link to this page but any form of unauthorized reproduction of this page's contents is expressly forbidden.

Supercharge your PPT Productivity with PPTools

content authoring & site maintenance by
Friday, the automatic faq maker (logo)
Friday - The Automatic FAQ Maker

What this section is about
Last update 07 June, 2011