Displaying Live data from Access.mdb ?

[Guest]

Hi all,
for this one project we are working on we have decided to use
Powerpoint as the front end to display data from an Access mdb. however I am
havign problems locating any type of means to 'insert' or 'link' the data
from Access. Searching around this forum i'm not having any luck finding a
solution except 3rd party software apps that link from CSV files or Excel,
which is pointless since I may as well use Excel to pull in the data then
insert the Excel sheet into Powerpoint.
I find it hard to believe that a Office product such as Powerpoint cannot
draw data from an Access Database.

Any advice please ?

Cheers in advance,
Mitch....

 

[Steve Rindsberg]

Is this something you're coding yourself or do you need a ready-made solution?

 

[Guest]

This is something I am coding myself, but I expect to see some sort of Data
'import' tool similar to Excel where I can link to a DSN connection and
refresh the data as I need.
For an Office product the lack of a data import tool seems a bit silly.

 

[Brian Reilly, MVP]

VegaLA,
This could be just what you are looking for.
http://www.pptfaq.com/FAQ00892.htm

Several of the MVP's collaborated to make this import feature work
either in Edit View or Slide Show view retrieving data from Access or
Excel. Code is unprotected. We just published it recently.

If you have any questions get back to use and we will explain more,
but you sound like you know what you are doing and should understand
our code and Comments easily.

Brian Reilly, MVP

 

[Steve Rindsberg]

This is something I am coding myself, but I expect to see some sort of Data
'import' tool similar to Excel where I can link to a DSN connection and
refresh the data as I need.

No such animal, I'm afraid.

Most features like this are driven by user requests, and to tell you the truth, we
maybe see one request a year here for linking Access data into PPT. If that's
typical of the kind of requests MS gets from other sources, it explains why they'd
spend their oil frying other fish.

But I see Brian's been along with the same link I was going to suggest, since
you're rolling your own code.

Have a look at the example file there. It includes routines to take data from
Access and build tables with it and/or to pull the data into an array; you can do
pretty much anything you need to with it from there.

You'll have to handle the refresh yourself, though. PPT has no real mechanism for
linking to Access data.

 

[Brian Reilly, MVP]

Steve,
No native way to Link but this solves the Insert request.

I suppose that one could pass enoughvariables tags to the Table shape
to permit an update. Mitch, look into Tags on PPT shapes.

Brian Reilly, MVP

 

[Guest]

Thanks Brian,
looks ideal, I hope to spend some time on this sometime
soon.

Thanks again =)