Export the worksheet to CSV and use the LOAD DATA command in MySQL to import it. That is how I import all but my most complex excel spreadsheets.
Mike Hillyer www.vbmysql.com -----Original Message----- From: D Crompton [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: Getting data in excel into a mysql table? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
