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
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'