Displaying Live data from Access.mdb ?

[VegaLA]

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....

 

[VegaLA]

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

 

[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

 

[VegaLA]

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

Thanks again =)