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.
