Importing Excel files to SQL database using VB.Net.
-
If anyone out there has some good code for importing Excel files into a SQL database using VB.Net, can you please share it so i can use it in my project. Basically what i want is an open file dialog to where you can select the file to import and a combo box display the different sheets of the file. Thanks.
-
If anyone out there has some good code for importing Excel files into a SQL database using VB.Net, can you please share it so i can use it in my project. Basically what i want is an open file dialog to where you can select the file to import and a combo box display the different sheets of the file. Thanks.
-
If anyone out there has some good code for importing Excel files into a SQL database using VB.Net, can you please share it so i can use it in my project. Basically what i want is an open file dialog to where you can select the file to import and a combo box display the different sheets of the file. Thanks.
Try the following link this might help Read excel File from VB You have to work around a bit in .Net but it will definately help for excel and for database insert browse the blog or go in the following link How to insert records in Sql Server from VB.Net ?
Blog for Programmers http://www.rprateek.blogspot.com