Using excel as database using vb.Net Or excel and VB.Net
Solution code:
Imports System.Data.Oledb
Public class form1
Private Const connstring As String = “Provider=Microsoft.Jet.OLEDB.4.0;” & _
“Data Source=c:\Test.xls;Extended Properties=””Excel 8.0;HDR=YES;”””
For full solution click here.