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
RexQuality LeaderAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Do you want to display the data in a table?

Or do you plan on doing something else with it?
0
RexQuality LeaderAuthor Commented:
I just want to display it as a table, no fuss other than maybe some formatting to pretty it up
0
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
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

NorieAnalyst Assistant Commented:
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
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
NorieAnalyst Assistant Commented:
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
RexQuality LeaderAuthor 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
NorieAnalyst Assistant Commented:
What is it you want exactly?
0
RexQuality LeaderAuthor 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
RexQuality LeaderAuthor 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
RexQuality LeaderAuthor Commented:
Same thing on this one. Pulled off. Won't be able to get back to it until April. Sorry.
0
RexQuality LeaderAuthor Commented:
Thanks. Sorry for long delay.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.