convert mysql to excel file version 4.0 or below in linux

Dear experts,

Is there other ways of convert mysql data into excel file or a better and easy way?

These are the methods that I know of:
1. using phpExcel (a php converter program)
2. using mysql OUTFILE command and dump the data into .xls file

I am trying to create an excel file from the data store inside mysql. The excel file has to be version 4.0 or below or else the other program will not recognize the file format.

Is there a mysql2excel command that I can use in linux which can get the job done? (concept is from dbf2mysql) If not is there a similar program that can perform the function of converting mysql data into excel?

Thanks
Kinderly WadeprogrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ThommyCommented:
You should try MySQL for Excel
0
ThommyCommented:
0
Kinderly WadeprogrammerAuthor Commented:
Hi Thommy,

Is there other ways that I can integrate the process of excel file generation into my code with a simple button click? I tried the MySQL for Excel. It is really good to extract data from MYSQL but I don't think I can setup a store procedure or function that can carry out the process of which database that I wish to extract my data from right? It is more like a manual process that needs to be done instead of automated process which can be simplified with a button click?
0
Simple Misconfiguration =Network Vulnerability

In this technical webinar, AlgoSec will present several examples of common misconfigurations; including a basic device change, business application connectivity changes, and data center migrations. Learn best practices to protect your business from attack.

ThommyCommented:
You may also directly output MySQL query results into csv format files for Excel:


For example like that:
SELECT idno, employee_name,salary FROM salaries
INTO OUTFILE '/temp/salaries.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Open in new window

0
Kinderly WadeprogrammerAuthor Commented:
Is it possible that I can do this:

SELECT idno, employee_name,salary FROM salaries
INTO OUTFILE '/temp/salaries.xls'
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Will this give me a readable output excel file or or it is better to go with csv?

I read up the mysql OUTFILE which it supports csv and txt.
0
ThommyCommented:
Not sure if that works!

But simply try it out...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kinderly WadeprogrammerAuthor Commented:
Thanks Tommy.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.