From: Daniel Brown (parasanegmail.com)
Date: Tue Apr 15 2008 - 14:18:18 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Tue, Apr 15, 2008 at 3:11 PM, minky arora <minky.aroragmail.com> wrote:
> Hi Gurus,
> I am a newbie.Please bear with me.
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?

    mysqldump is for exporting data. What you're looking for is the
"LOAD DATA [LOCAL] INFILE" command.

    Dump out your Excel data to a CSV and import it by using the
manual entry as a guide:
        http://dev.mysql.com/doc/refman/5.0/en/load-data.html

--
</Daniel P. Brown>
Ask me about:
Dedicated servers starting $59.99/mo., VPS starting $19.99/mo.,
and shared hosting starting $2.50/mo.
Unmanaged, managed, and fully-managed!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]