Hello
Export the data in CSV from Excel and then you can try
SQLyog at http://www.webyog.com/sqlyog
It has a very good interface to import data from CSV
file.
Karam
--- D Crompton <dannycrompton@stripped> wrote:
> I have an MS excel file with 8 columns and 500 rows
>
> I have a table called 'names' setup in mysql which
> i have created with 8
> columns.
>
> I now need to get my data from excel into that
> table.
>
> How would u do this?.
>
> I had a look in mysqlcc to see if there was an
> import option but couldn't see one
>
> Advice v much appreciated
>
> thanks
> Dan
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
