|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#3
July 18th, 2003, 10:14 PM
|
|||
|
|||
|
RE: Microsoft Excel Output?
Here is a link to a mysql to XL converter.
http://www.churm.com/konvertr/index.php
|
|
#4
July 18th, 2003, 10:20 PM
|
|||
|
|||
|
RE: Microsoft Excel Output?
Here is a link to a PHP script that generates Excel or Word docs.
|
|
#5
July 18th, 2003, 10:21 PM
|
|||
|
|||
|
RE: Microsoft Excel Output?
forgot the link.
http://devscripts.com/viewscript.php?sId=1313
|
|
#6
July 23rd, 2003, 01:34 AM
|
|||
|
|||
|
RE: Microsoft Excel Output?
I might be reading this all wrong, but my understanding is that you want to take the output from a MySQL query, and import it into an Excel spreadsheet. (If I am incorrect on this, I apologize)
There are multiple ways to do it, but two simple ways are: 1) you can export the data as csv. It's been awhile since I've used MySQL that much, but i'm pretty sure there's a 'select into outfile.csv ...' command. 2) You can use MySQL odbc through excel. This is a bit more tricky, but install the MySQL ODBC driver, and configure it for your database, then open Excel, and go to Data->Get External Data->New Database query. It should then launch MS query editor, and you can create your query there. The biggest problem with either of these methods is that you will need to format the data each time that the query is ran. Hope this helps some.
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Microsoft Excel Output? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
