Access to Powerpoint

[J]

Has anyone ever tried to push data from Access into a powerpoint file? We have a welcome board that we put today's visitors' names into and display it on a monitor. We would like to write an access application that will push the information we want (name, city) into the correct PORTION of the page.

We have the powerpoint slideshow scrolling through the list of names, with a consistent header with our company name. The names go at the bottom.

The problem is, when I export the file to excel, and import it into Powerpoint- it will by default, always load the db info in the top section.

Is there a way where I can specify to load the imported data in a specific section of the powerpoint slide?

Thanks
J

 

[Kurt]

Hi J,
Have a look at www.take-off.as/datapoint and
www.take-off.as/datapoint/workshop/WelcomeVisitors.htm

Kurt

Has anyone ever tried to push data from Access into a powerpoint file? We

have a welcome board that we put today's visitors' names into and display it
on a monitor. We would like to write an access application that will push
the information we want (name, city) into the correct PORTION of the page.

We have the powerpoint slideshow scrolling through the list of names, with

a consistent header with our company name. The names go at the bottom.

The problem is, when I export the file to excel, and import it into

Powerpoint- it will by default, always load the db info in the top section.

Is there a way where I can specify to load the imported data in a specific

section of the powerpoint slide?

 

[Brian Reilly, MS MVP]

Yes,
You can integrate Access content into PPT. It's not as easy as linking
data from Excel but it can be done with VBA and you can control the
formatting as well as the content. I'm about to start a project like
this creating hundreds of PPT files from a SQL Server database, all
driven from PPT.

If you know VBA, there are many examples on the MSKB to do this. If
you don't know VBA, you might want to find someone who does. Not
really that tough.

Brian Reilly, PowerPoint MVP