i want to upload a csv file to mysql database.but it does not work...?

Question

i checked it even..first i export the csv format file from my database(mysql) and after edit it in excel and save as csv..when i try to import this file in my database...it throws errors..even again i did this without editing this.to be confirmed again this gave me error..
so please tell me how to get the work done..

Answer 1

It helps to give the MySQL error that was given...

Answer 2

With very own abode web site you could desire to apply the csv very own abode web site purposes to learn the csv checklist and then shop them on the database. this is no longer confusing. in reality you would be doing: $fp = fopen('csvfile.csv'); $records = fgetcsv($fp,filezise('csvfile.csv'),',')... it particularly is going to return an array with the concepts and then all you could desire to do is to shop that records indoors the database indoors the way which you think of of ultimate. have relaxing

Answer 3

Use http://www.modwest.com/help/kb6-253.html



You can write very simple script to read you csv file and move it to database



Thanks,

Vinay