Can I use VBA to Import the Content of an Access Table into a PowerPoint Slide?

I need to get the contents from an Access table into a PowerPoint slide. I use a PowerPoint macro to load updated graph images etc...but I also need it to import the data from an Access table. Any help would be appreciated. Thanks
Rex85Asked:
Who is Participating?
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
0
 
NorieVBA ExpertCommented:
Do you want to display the data in a table?

Or do you plan on doing something else with it?
0
 
Rex85Author Commented:
I just want to display it as a table, no fuss other than maybe some formatting to pretty it up
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Rey Obrero (Capricorn1)Commented:
here is a sample code to create a graph in power point with datasheet from access recordset

http://support.microsoft.com/?kbid=200551
0
 
NorieVBA ExpertCommented:
Try this link.

http://www.pptfaq.com/FAQ00892.htm

In the file you can download there's an import 'wizard' that will let you choose an Excel file or Access database.

The code will only handle MDB and XLS files, but could be update for then 'new' file types for Access/Excel.
0
 
Jeffrey CoachmanMIS LiasonCommented:
How will it fit onto a slide if there are hundreds, or perhaps thousands of records?

I will presume you need this data to be "Linked", ...this may be more complex...

As you can see form the links TheHiTechCoach posted, this may not be what you would call "easy"

;-)

Jeff
0
 
NorieVBA ExpertCommented:
In the link I posted the code creates a slide for each 25 records.

Again probably not practical, but I doubt that you would want to actually display large amounts of data in a slideshow.

It's probably more likely some sort of summary (cross-tab) would be wanted.
0
 
Jeffrey CoachmanMIS LiasonCommented:
imnorie,

Yeah, that's what I thought too.

I just thought I'd mention it to the OP, ...just in case...
;-)

Jeff
0
 
Rex85Author Commented:
FYI...Haven't forgotten this. Holidays obviously intervened. Definitley not simple. None of the examples exactly what I'm looking for....trying to borrow parts of them to create what i need without screwing them up.
0
 
NorieVBA ExpertCommented:
What is it you want exactly?
0
 
Rex85Author Commented:
I have a Make Table Query in Access that has all the info I want, arranged as desired, so I don't need anything in Access or that runs from Access.

I have a macro in a PowerPoint Template that I run weekly. It fills the template slides with the appropriate chart images in the right places, so I don't need any chart creation.

What I want, is for the above mentioned PowerPoint macro to also take the data from the above mentioned Access tables and create tables of that information on appropriate slides. I would say most tables contain 7 - 10 records, so they should fit on a slide.

Does that make sense?
0
 
Rex85Author Commented:
I am still trying to adapt the info in the link provided to my needs. I do not know what I am doing, and I have too many irons in the fire. Sorry for the lenght of time I am taking.
0
 
Rex85Author Commented:
Same thing on this one. Pulled off. Won't be able to get back to it until April. Sorry.
0
 
Rex85Author Commented:
Thanks. Sorry for long delay.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.