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 <[EMAIL PROTECTED]> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
