Looking quickly at PowerPoint, you *can* do what you want to do, however, here's the catch, there is no quick way to pull from a file or data source and have it write to the field in pp. You can do some VB trickery with the built in VBA in it, where you can use the MySQL ODBC driver and could read from a db and write to the screen. Another (probably better) way would have a standalone app read the db, and with some GUI (could be VB) take over the screen (such as pp does) and display the music. I'm not sure how your church is setup with the pp presentation, but these are my initial thoughts on the matter. I realize you aren't a programmer, however, from a quick run through, I don't see a way to do what you are asking with out any programming. MSQuery is a program that usually comes with office that allows you to connect to db's inside of office apps. A DSN is a way for programs to connect to DBs (simple description). You can setup DSNs in systems under Data Sources (ODBC) under administrative tools (windows 2k/xp). HTH
Thanks, James -----Original Message----- From: redhat [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 3:45 PM To: mysql Subject: RE: powerpoint and mysql On Fri, 2004-08-27 at 14:30, Victor Pendleton wrote: > How did you plan on using the information pulled from the database? If you > are currently using MS Query or a DSN you can modify the current connection > information to point to your MySQL database. > > -----Original Message----- > From: redhat > To: mysql > Sent: 8/27/04 2:21 PM > Subject: powerpoint and mysql > > Greetings, > I'm new to the list. > I was wondering if it is possible to user mysql and powerpoint? I have > a small database of simple text entries that I want to create whereby I > can pull a title up and have the rest of the slide dynamically > generated. The reason for this is that the presentation data will > change weekly but over time the data will be used over and over - so I > don't want to lose it or have to re-enter it. Any ideas? > thanks, > Doug That is part of the equation. I know that in ppt I can add "objects" but I don't see anywhere for any kind of datasource. I didn't know if anyone was working on a possible plugin or maybe knew of a way to make it work. Here's what I am doing. I handle all of the music at my church. Every week we use a projector and a laptop to put the words to the songs on a screen. I am taking the task of putting the songs on the laptop and realized that for the past two years they were creating new presentations for each week. I think this is a waste of time. At a bare minimum I am going to dump all of the songs into some sort of text document in a single directory - named by the title of the song. I use mysql (I'm not a programmer) on some very simple php/mysql stuff at work and am familiar with inputting data and then retrieving it again. If I could have a db with just two columns (title, song) I and a way to actually "import" this data to ppt I could make it work. In a perfect world I would create a much larger db with song keys, dates of last play, etc. I hope this clears my request up. As for "MS Query" or "DSN", I don't use MS Query (not sure what it is) and I have no clue what DSN is either. Sorry. Thanks for the input. Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
