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