06 10401510 info@99projects.nl
csv2 sql

CSV to Mysql

This Php Script Will Import very large CSV files to MYSQL database in a minute


eg. MYDATA.csv
0) echo "Success"; echo " total $count records have been added to the table $table "; } else{ echo "Mysql Server address/Host name ,Username , Database name ,Table name , File name are the Mandatory Fields"; } ?>

Instructions

1. Keep this php file and Your csv file in one folder
2. Create a table in your mysql database to which you want to import
3. Open the php file from your localhost server
4. Enter all the fields
5. click on upload button

Facing Problems ? Some of the reasons can be the ones shown below

1) Check if the table to which you want to import is created and the datatype of each column matches with the data in csv
2) If fields in your csv are not separated by commas go to Line 117 of php file and change the query
3) If each tuple in your csv are not one below other(i.e not seperated by a new line) got line 117 of php file and change the query
Onze Nieuwsbrief ontvangen?

Onze Nieuwsbrief ontvangen?

Schrijf je in voor onze Nieuwsbrief en ontvang het laatste nieuws als eerste!

Inschrijving geslaagd!