Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Daniel Brown (parasanegmail.com)
Date: Tue Apr 15 2008 - 14:18:18 CDT
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:
</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