David Blomstrom wrote:
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"
It would be better to post some of the lines that did not import. Posting a "show create table" would also help.
__________________________________
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]
