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.
| 
