I save as CSV (MS-DOS). I then import into MySQL using SqlYog and the following parameters:
Line terminator \r\n Delimiter , Strings Optionally surrounded by " That gives me a successful import every time. I have tried other variations and achieved same results as you - 'jumbled' data. Greg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 September 2003 15:29 To: [EMAIL PROTECTED] Subject: Excel 2 CSV into phpMyAdmin is there a trick to saving Excel spreadsheets into a CSV format that will import into MySQL or phpMyAdmin reliably? my CSV files get jumbled up, if they load in at all. There is a bug i have been told concerning columns that contain alphanumeric and just numeric fields. I use Excel [office 2k version] on Win2k to create my CSV files. and the target apps and database is phpMyAdmin 2.5.3-rc3 with MySQL 3.23.56 -- Regards, Carmoda [EMAIL PROTECTED] ==================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
