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:dannycrompton@stripped]
Sent: Wednesday, May 28, 2003 9:51 AM
To: mysql@stripped
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
