The quick answer is to save your data as a comma delimited file with no headers. (I suggest actually using bang | since your data may contain commas.)
Then look in the docs for the "load data in file statement." Be careful to note the fields delimited by, lines terminated by and such. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -----Original Message----- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 8:53 AM To: [EMAIL PROTECTED] Subject: Best method to export Excel data into MySQL? What would be the best method (using free tools, or Office suite) to export an Excel spreadsheet into a format suitable for import into MySQL? I am on a PC platform. Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
