Click here to Skip to main content
14,882,311 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to read data from Excel sheet and store in mysql table by using browse button.
Can any one help me?
Posted
Updated 17-Jan-12 21:06pm
v2
Comments
Michel [mjbohn] 18-Jan-12 3:08am
   
What have you done so far?
Show us some code and we will gladly help you with it.

1 solution

Like mjbohn says what have you done so far. I assume by a browse button you mean uploading. If so, here is what you do.

1. Upload the file
2. Open the file on the server using the Excel Object Model
3. Write SQL code to insert the values you want from the file into the db.
   
Comments
janareddyjanareddy 2-Mar-12 2:06am
   
Ya same procedure Can yo Provide the sample code to open excel sheet in server

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900