Click here to Skip to main content
15,867,686 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.
 
Share this answer
 
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