List:MySQL++« Previous MessageNext Message »
From:Jim Wallace Date:September 24 2008 11:25am
Subject:RE: dump from mysql to "xl" file
View as plain text  
If you have to do it from code, kicking out a csv would be easiest.  If
it's a one-time thing use the mysql command line tool's --xml option
which Excel will read.

-----Original Message-----
From: Ian Daysh [mailto:I.Daysh@stripped] 
Sent: Wednesday, September 24, 2008 4:54 AM
To: plusplus@stripped
Subject: RE: dump from mysql to "xl" file

As Warren has said, to get something into Excel will have to be a 2-part
process.

1) Using MySQL++ for data retrieval
2) Generating a file suitable for Excel.

I had a similar issue, and ended up finding that Microsoft have
reasonable documentation for their xml spreadsheet format where you can
specify formatting, tabs etc. This ends up being much easier as you can
write to a plain text file.

Ian.

-----Original Message-----
From: Warren Young [mailto:mysqlpp@stripped] 
Sent: 24 September 2008 06:03
To: MySQL++ Mailing List
Subject: Re: dump from mysql to "xl" file

manish wrote:
> What are the function present in mysql++ for dump the database into 
> microsoft XL file.

There are no large-scale data format conversion functions of any sort in

MySQL++.  That is not its purpose.

You could use MySQL++ to write such a thing, with MySQL++ handling the
"read from MySQL" part, but it would be up to you to figure out how to
write the data you retrieve out in Excel format.

If you just need a simple one-time data conversion (i.e. not something
ongoing or needing automation) I recommend MySQL's Query Browser tool:

	http://dev.mysql.com/downloads/gui-tools/5.0.html

-- 
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:
http://lists.mysql.com/plusplus?unsub=1



-- 
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:
http://lists.mysql.com/plusplus?unsub=1


Thread
dump from mysql to "xl" filemanish24 Sep
  • Re: dump from mysql to "xl" fileWarren Young24 Sep
    • Re: dump from mysql to "xl" fileRick Gutleber25 Sep
  • RE: dump from mysql to "xl" fileIan Daysh24 Sep
    • RE: dump from mysql to "xl" fileJim Wallace24 Sep
  • Re: dump from mysql to "xl" fileJonathan Wakely25 Sep
  • Re: dump from mysql to "xl" filemanish26 Sep