> On 14-Jun-01 Terminal Velocity wrote:
> > I would like to use MySQL to manage my company data, but my clients want
> > all their information sent to them in an Excel spreadsheet. Presently I
> > use Access, and export a SELECT statement into Excel, and then make a
> > couple changes to the Excel file (I just high-lite the updated data).
> >
> > I want to change the database to MySQL on a Linux box, but the biggest
> > issue is being able to export into Excel. I know I can export to a
> > tab-delimited text file, but I would prefer to do it all in one step.
> >
> > Any ideas?
Do they want the information sent to them, or accessible via the internet.
In either case a CSV file is normally sufficient. If you want access via the
internet it's pretty simply to produce a page that displays an excel file
(actually it's CSV) in Excel within their browser which looks quite
impressive. Email me for details and I'll post the method up here. It
invloves using PHP and Apache.
Alternatively if you want to dump to a CSV file any language will do.
Personally I'd use C or PHP.
Highlighting and graphing data, you're on your own, although you *may* be
able to incorporate a formula to do this in the CSV IIRC.
Russ.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
