On Thu, 2008-06-12 at 20:33 -0400, Drew Jensen wrote: > Keith Clark wrote: > > On Thu, 2008-06-12 at 20:23 -0400, Drew Jensen wrote: > >> Keith Clark wrote: > >>> I seem to be having problems importing a file that I've saved as a .csv > >>> file from calc. I'm using phpMyAdmin and it seems to have errors in > >>> the .csv file import. I look at the reported line numbers with the > >>> errors and nothing is wrong. I don't know if it is a problem with the > >>> file generated with Calc, or a problem with phpMyAdmin. Any ideas on > >>> how to check this problem out? > >>> > >> A good place to start would be by passing along the actual error > >> code/message that MySQL (it is MySQL right? - version?) is returning. > > > > Hey Drew! > > > > Okay, here is the error: > > > > Invalid field count in CSV input on line 1381. > > > > Using: > > > > MySQL - 5.0.45 > > > > I look at my file and there is no difference in the records surrounding > > this line and the actual line given in the error. > > > > Keith > > > > LOL MySQL disagrees with you..LOL. > > Try downloading this tool and running the file through it and see what > it thinks line 13...whatever looks like. > > http://webscripts.softpedia.com/script/Database-Tools/CSVEdit-16225.html
Drew, Wow, I didn't want to have to learn yet another program! That seems to be a complex way to troubleshoot the problem. I will learn it regardless! Thanks, Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
