I was sent an excel file from a remote office, and need to put the data
into a mysql database to be displayed on our web site. I removed a few
lines of fluff from the excel file and saved it as .csv (using .csv
(ms-dos)). When I try to import the file it gives me a duplicate entry for
key 1 error. I have looked through the file and the duplicate item it is
pointing to does not exist in the file. Here is the error:
mysql> load data infile '/usr/home/autopilots/whs4.csv'
-> into table refurbs
-> fields terminated by ','
-> optionally enclosed by '"'
-> lines terminated by '\n';
ERROR 1062: Duplicate entry '2147483647' for key 1
(When I try to import through phpMyAdmin-2.5.6 it doesn't work also, keeps
telling me to load a file, which is done by pressing Browse button.)
Any ideas what could cause it to fail on a non-existant key? Is there a
trick to loading Excel .csv files into mysql?
Thanks
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
www.simrad.com
[EMAIL PROTECTED]
"When I'm working on a problem, I never think about beauty. I think only
how to solve the problem. But when I have finished, if the solution is not
beautiful, I know it is wrong." - R. Buckminster Fuller
