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