insertng csv - solved

A HUGE thank you to Michael and John.

There were a couple of things going on.... but I do not know why things got the way they were.... can only assume the client files had some issue.

I pulled the file into text wrangler and removed

, `20` , `21` , `22` , `23` etc.

Then counted the number of extra commas for the lines, did a find replace and removed them. If there hadn't been so many, that trick would have been nearly impossible though.

Then, on a hunch, I removed clients column content for how they had entered dates: 1/11/09 type of entry. Just blanked it out. Tried to import and it stopped at line 17 (again). BUT progress!

So, went back to the converter and entered into SQL on phpmyadmn interface... viola! success.

Thank you both so much for your help.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

--

Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com

--

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@pantek.com Received on Thu Oct 15 14:13:02 2009