import the data from excel to mysql

Posted by Chanti444 under ASP.NET on 11/7/2011 | Points: 10 | Views : 1486 | Status : [Member] | Replies : 1 new in this forum and php language..i need a help..anybody know how to import excel data into mysql Database? a student for the final year and making a me..tq so much..



Posted by: Nilschaudhari on: 12/13/2011 [Member] Starter | Points: 25


As you said you use PHP so I told the only logic as I am not familier with PHP.

First the Read the Excel file into dataset or datatable using the appropriate drivers for that in .net we use oledb drivers for the same,

then use the for loop at the end of the records

and in that loop call your insert code

Chanti444, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response