I was hoping that (somehow...) I could "tag" the data and tell Excel where to put it within a spreadsheet.
Thanks.
On Mar 2, 2005, at 1:09 PM, Bj wrote:
1. The easy peasy way is to export the date as a csv (comma separated
variable) file. Write some php to read data from mysql and create a file
with a .csv file extension in this kind of format:
Name,City,Age,Children "Sara Brooks",Chicago,25,0 "Pete Yates",Reading,27,2
ftp the file or have the script email to you or download it from a link,
just get it onto your desktop. Now open Excel and at the File Open dialog,
set file type to "All files" or "Text files (.txt, .prn, .csv)"
When you open the file, Excel will fairly simply read it into a spreadsheet
where you can analyse it, sort it or whatever you want . Just make sure
strings in the data are enclosed in single or double quotes (and watch out
quotes inside the string!)
2. I never got it to work cos I didn't try hard enough, but there's
something called myAccess that runs on your desktop and manages your mySQL
database on the Web site as a local Access database, and Access of course
has excellent reporting facilities, see http://www.hiden.org/myaccess/
----- Original Message ----- From: "steve miller" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, March 02, 2005 4:30 PM Subject: [wdvltalk] making pretty reports
mailto:[EMAIL PROTECTED] orHi all.
Looking for suggestions.
We have lots of data in mysql on a BSD box. We are looking for a way to
output the data, and insert it into some application where we have set
up report templates to be able to view and print the reports.
Right now, we manually enter all the data into Excel spreadsheets and
use Excel to create the formatted reports. What we want to do is export
the mysql data from the BSD box to the desktop, and somehow open the
template and import the data into the correct fields. Is this possible?
Are there other ways to do something like this?
Any ideas to get me headed the right way are appreciated.
steve
____ . The WDVL Discussion List from WDVL.COM . ____ To Join wdvltalk, Send An Email To:use the web interfacehttp://e-newsletters.internet.com/discussionlists.html/Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016
Please include the email address which you have been contacted with.
