Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 7215
Home > Forums > ASP.NET >

import the data from excel to mysql

Posted by Chanti444 under ASP.NET on 11/7/2011 | Points: 10 | Views : 2312 | Status : [Member] | Replies : 1
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
hello..im new in this forum and php language..i need a help..anybody know how to import excel data into mysql Database?..im a student for the final year and making a project..help me..tq so much..

satya

Reply | Reply with Attachment
Alert Moderator 

Responses

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

Up
0
Down
hi,

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

Latest Posts