Re: How to import data from MySQL db into excel sheet

From: John Nagle <nagle@xxxxxxxxxxx>
Date: Thu, 30 Jun 2011 11:00:15 -0700

On 6/2/2011 5:11 AM, hisan wrote:

Please let me know how can i import my sql data of multiple rows and
columns into an excel sheet.
here i need to adjust the column width based on the on the data that
sits into the column

You're asking in the wrong forum. Try the MySQL forum or an
Excel forum.

For a one-off job, use the MySQL Workbench, do a SELECT, click on
the floppy disk icon, and export a CSV (comma-separated value) file, which Excel will import.

It's possible to link Excel directly to an SQL database; see
the Excel documentation.

On a server, you can SELECT ... INTO OUTFILE and get a CSV file
that way, but the file is created on the machine where the database
is running, not the client machine.

You can write a Python program to SELECT from the database and
use the CSV module to create a CSV file, but as a one-off, it's
not necessary.

John Nagle
.

Prev by Date: Re: how to call a function for evry 10 secs
Next by Date: Re: Is the Usenet to mailing list gateway borked?
Previous by thread: treeviewcontrol in tkinter.ttk
Next by thread: text file
Index(es):
- Date
- Thread

Relevant Pages

Re: Reconciling Employee Forms and Database Records
... You could also use Excel as the file format to send the data out and import ... the document the form loads from the CSV file and when they update a field ... > I have an employee database. ... provided the data that the database stores. ...
(microsoft.public.access.externaldata)
Re: Exporting CSV files to Excel
... I tried to export data from an external database to both my Mac ... Book or my iMac Excel. ... but Excel doesn't process the CSV file appropriately (everything ends up in ...
(microsoft.public.mac.office.excel)
Re: CSV import, excel corrupts data
... I guess if you want to use excel, you'll have to play by its rules. ... If opening .csv files directly doesn't work for you, ... Doing the macro trick corrupts the data as described when the file is a ... empty worksheet, use the data import wizard to select the csv file, ...
(microsoft.public.excel)
Re: CSV import, excel corrupts data
... It _does_ bring up the data import wizard. ... There really seems to be no way to accomplish this in excel. ... Doing the macro trick corrupts the data as described when the file is a ... empty worksheet, use the data import wizard to select the csv file, ...
(microsoft.public.excel)
Re: Basic Program to Import a CSV file
... Given that the OP asked about importing a CSV file into UV, ... some Excel to MV tool to import a CSV file into UV? ... Hey, why stop at replacing the database, replace the spreadsheet tools ... The directory file may well be UV ...
(comp.databases.pick)