gpiyush152 says:
i want proper design and code so please give me that
What else you expect from us? A reference link is already provided.
1. First of all please gain knowledge of why OLEDB is used. For that you must read article.
OLEDB is used for reading Excel and not for inserting in SQL Server.
2. You said you don't need OLEDB, we have given option of OpenXML.
3. Proper Design and Code? Please. We are not here to code for you. We create and give basic simple examples to learn, and then modify to advance level as per your project.
I hope I have cleared everything.