Here's a little heads-up, as you will need some XML coding to make it "look right".
PLEASE NOTE: I'm an ASP programmer, so PHP is a little foreign to me. You will need to do some conversion. Here is the way to do it: 1) Define your recordset and connection strings. 2) Write PHP strings to add ContentType (or similar call) = "application/vnd.ms-excel" 3) (optional) Write PHP echo strings for adding XML tags. (You can find these at http://msdn.microsoft.com, although I'll be damned if I can find them now. Ask for them and I will get them from my other computer and send them on.) 4) In the <body> of your webpage, put the following snippet: <body> <table width="100%"> <thead> <tr> <td>Col 1</td> <td>Col 2</td> ... <td>Col end</td> </tr> </thead> <tbody> <?PHP Open the records, pull the set 'do the loop movefirst while not eof ?> <tr> <td><? PHP DATA 1 ?></td> <td><? PHP DATA 2 ?></td> ... <td><? PHP DATA end ?></td> </tr> <?PHP Next in loop Wend Close ?> </tbody> </table> </body> </html> I hope this helps a little! J.R. PS - Shawn FYI, if you copy and paste a tab into the replace with in notepad, you can do it that way... -----Original Message----- From: Nick Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 3:19 PM To: mysql@lists.mysql.com Subject: RE: Populate values in an Excel sheet from MySQL --- "J.R. Bullington" <[EMAIL PROTECTED]> wrote: > Automatically populate?? > > Not that _I_ know of, but of course there are those on this list that > know much more than I. > > I do know that you can export the values into tab delimited format and > then import it into Excel. > > I think that you may want to do this via ASP or PHP. > It would make life a > lot easier. > > J.R. PHP would definitely be the way to go on this. I'm working on a web application running on our AS/400 here running Apache, PHP, and MySQL to automate our schedule forms that we fill out daily around here. Everything I've got so far is running through PHP/MySQL so if I can find a way to do this in PHP I'm definitely going to try. I'll google around for awhile and see what I come up with. MS Knowledge Base has proven to be less than useful so far in my endeavor. Also, thanks to James for his suggestion on using the ODBC query directly from Excel. This will get us started for the time being, and give me some leeway so I can work on doing this in PHP. Thanks to you both! -Nick ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs -- 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]
