On Tue, Apr 15, 2008 at 3:11 PM, minky arora <[EMAIL PROTECTED]> 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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
