LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-01-2004, 10:54 AM   #1
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Rep: Reputation: 30
Question sql to xls


sup guy's

i gave 1 file sql and i want convert this file to xls where i can convert the file? or if are 1 program to do that..

tkx
 
Old 11-01-2004, 11:11 AM   #2
toddnappi
LQ Newbie
 
Registered: Oct 2004
Location: NJ
Posts: 16

Rep: Reputation: 0
Assuming you are using MySQL, it seems there are no default built-in export utilities. Here is a pretty good tutorial on how to do it without purchasing one of those plugins: http://www.phpfreaks.com/tutorials/114/0.php
 
Old 11-01-2004, 12:06 PM   #3
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Original Poster
Rep: Reputation: 30
yes.. but dont have any program do that?
 
Old 11-01-2004, 12:09 PM   #4
toddnappi
LQ Newbie
 
Registered: Oct 2004
Location: NJ
Posts: 16

Rep: Reputation: 0
Doing a quick search on google... seems they all have an associated cost. However I only looked at the first few, a more in depth search could yield better results.
 
Old 11-01-2004, 12:19 PM   #5
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Original Poster
Rep: Reputation: 30
yes but for linux i can find :S
 
Old 11-01-2004, 01:31 PM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Ummm ... xls is a spreadsheet file format, sql
is database query language ... what exactly
are you trying to achieve?


Cheers,
Tink
 
Old 11-01-2004, 01:35 PM   #7
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Original Poster
Rep: Reputation: 30
i what passe 1 file .sql ti excel ".xls "
if 1 program do that.. convert 1 file sql to excel " xls "

tks
 
Old 11-01-2004, 01:40 PM   #8
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Mate ... give us an example of the content of
your "1 file sql" ... I still have no idea of what
you're trying to achieve.


Cheers,
Tink
 
Old 11-01-2004, 01:52 PM   #9
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Original Poster
Rep: Reputation: 30
i have 1 file.. dump.sql
and i want convert this file do excel " xls "
 
Old 11-01-2004, 02:05 PM   #10
looseCannon
Member
 
Registered: Dec 2003
Location: Little Rock, AR
Distribution: Fedora Core 2, AIX, HP-UX, Solaris, Whitebox
Posts: 193

Rep: Reputation: 31
What you are probably looking for is getting it into a CSV type format. Excel can read that in and use it in a spreadsheet.

Not sure about a flag in mysqldump that can do this, but you could very easily write something in perl, bash, php, python, or any number of other languages that would do what you want.
 
Old 11-01-2004, 02:07 PM   #11
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Original Poster
Rep: Reputation: 30
yes.. but where i can covert? any program?
tks
 
Old 11-01-2004, 02:10 PM   #12
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Look mate ... it depends on WHAT IS IN THAT FILE.

Is it the RESULT of a query, or is it a QUERY?

I asked you about the content of it for a reason.

That aside, you can find help here



Cheers,
Tink
 
Old 11-01-2004, 02:12 PM   #13
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,569

Rep: Reputation: 171Reputation: 171
Hmm...If it's just a text format and you have the filed in dump.sql separated with spaces or tabs you should be able to open it in any spreadshet as a file in CSV format.
 
Old 11-01-2004, 03:03 PM   #14
j.vilon
Member
 
Registered: Sep 2004
Posts: 168

Original Poster
Rep: Reputation: 30
yes, but is on text format.. and i want covert this on excel file.. i think u dont understand
 
Old 11-01-2004, 03:23 PM   #15
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
i can assure you we all understand perfectly, and you have already been provided you with all the answers you'd need...

you just keep repeating the same 2 lines over and over again...

there is no real reason it should be possible to convert from an sql query into a proprietry format data file for an application that doesn't even work on this platform.

convert it to a CSV file. if you don't know what a CSV file is, look it up. Excel CAN read this.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
database or xls doc? mifan Programming 6 09-05-2005 05:22 PM
xml to xls matt1982 Programming 5 12-16-2004 12:47 PM
Opening xls Excel Docs on Linux ddrfreak Mandriva 2 12-14-2004 12:09 AM
.doc, .xls & .jpg became 0kb paeng16 General 1 07-30-2004 09:21 AM
export .xls into a mysql table anyone? h/w Programming 1 03-17-2004 11:36 AM


All times are GMT -5. The time now is 04:02 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration