Can PowerPoint export data to Access?

  • Thread starter Thread starter Paul Valente
  • Start date Start date
P

Paul Valente

Hello to all

I know that PP can display data from other sources like Access in it's
slides, but can the PP send data to an Access table?

I have a number of presentations that are used for safety training that are
dispensed by cd-rom throughout our organisation
for personnel to run periodically. At the end of the presentation there are
a number of True or False questions
that the user answers by selecting the appropriate response with the mouse.
The selections are all controlled by VBA to tally their
response against an array of correct answers, it then determines the score
out of 100 and prints a certificate at the end with their name,
the date tested and the valid to date included. Their names are entered
from a custom user form built into the presentation.
I would like to have these instances recorded into our Safety Management
database to allow us to keep track of this training .

At the moment all data is sent by the presentation to a delimited text file
on the server using the Open and Print statements,
after which the file is read and appended to a table using Access. I've
tried to declare and open a recordset and send the data through to Access
but it won't work as PP doesn't use the Jet Engine to handle data. I want to
automate the data gathering as much as possible as there are lot of
personnel to train.

My question is there another way to accomplish this using VBA or is there an
add-in available that will allow this data transfer?

Thanks for listening to my problem.

Regards
Paul
 
Paul,
I'm certain that you can send data back to Access from PPT. It's the same
code which you would use lets say from a VB app. Which part is not working
for you?
 
Shyam
Thanks for responding.
I don't know how to access a table using VBA from PowerPoint. I tried to use
a Recordset or DataObject as you would in Access but PP didn't accept the
syntax.
I need to know how to structure the code to send the data to the database
table.

Paul
 
Shyam

Once again thanks for your response.
Just a note to say I found the solution to my problem. I needed to set the
reference to the DAO Object Library in the Visual Basic Editor, don't
normally think about that one as Access takes care of it by default. All
declarations were then recognised.

Paul
 
Good to know that.
--
Regards
Shyam Pillai

Paul Valente said:
Shyam

Once again thanks for your response.
Just a note to say I found the solution to my problem. I needed to set the
reference to the DAO Object Library in the Visual Basic Editor, don't
normally think about that one as Access takes care of it by default. All
declarations were then recognised.

Paul
Click to expand...
 
Paul

I am looking to have this set up for my organization.
Is there a way i can contact you directly?
Would appreciate it

Thanks
 
Back
Top