Here is simple online convertor from CSV to SQL. You just insert CSV data to text area and table name. Script will generate SQL insert query for all records from CSV.
Vinay: Sorry for stupid issue, I moved server and didn't turn on register globals in PHP. Script is now working. Thanks for feedback and sorry for long time to fix it.
Hi phil, can you give me few rows of CSV Data and specify if you are generating code for MySQL or MSSQL? I will take a look where is problem and fix script.
Hi Jeff, you are right, this is really simple script to convert CSV without column names in first row. I will modify it in future to get better results. Thanks for you note.
Comments
In the recent past ( last few days), when I have tried it, returns empty Inserts :
INSERT INTO [Weights] () VALUES ();
Here is one of the Rows I was trying to create Inserts for
d_MeasurementDa te,i_DayNum ,f_Weight
5/14/2008,13,53.71
5/19/2008,18,54.15
Any ideas on what could be Wrong
Thanks
Vinay
VALUES ('16,16,category,,0,18');
you are right, this is really simple script to convert CSV without column names in first row. I will modify it in future to get better results. Thanks for you note.
RSS feed for comments to this post.