Access to Powerpoint

[Guest]

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

 

[Doug Bell]

I haven't tried that but it sounds a little bit clunky. If it is just one
message board, why not use a ASP and display it on a Browser. Access is OK
as the data source for that type of application and you can probably use
something like MS Personal Web Server

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?

 

[John Nurick]

Hi J,

You can use VBA code running in Access, Excel or Powerpoint to control
what happens, but Doug's suggestion of using browser technology sounds
neater.