I just discovered that one of my MySQL tables is incomplete. I created it by importing a comma delimited file I had made from a spreadsheet, but it appears as many as 3,000 rows or so were missing.
So I decided to give it another try. MySQL Front refused to import it because of some sort of error I haven't yet identified. Navicat imports it, logging roughly 80 errors. When I view the finished table, many of the entries in the first field are followed by ",. For example... al", tx", Here are a few rows from the comma delimited file I imported. Do you have a hunch what might be going on here? Thanks. "gd","oat",239,,"Grenada","nat" "gp","oat",240,,"Guadeloupe","dep" "ht","oat",241,,"Haiti","nat" "is","oat",242,,"Iceland","nat" "jm","oat",243,,"Jamaica","nat" __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]