Best method to export Excel data into MySQL?

2004-08-20 Thread Eve Atley
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:

RE: Best method to export Excel data into MySQL?

2004-08-20 Thread Boyd E. Hemphill
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

Re: Best method to export Excel data into MySQL?

2004-08-20 Thread Duncan Hill
On Friday 20 August 2004 15:58, Boyd E. Hemphill might have typed: 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.) A properly comma delimited file will not have problems with commas in the