This is what your after mate How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
Good luck ( I hate DB stuff :/ )
Anyone pls tell me or give me some links..how to control excel as my database using vb.net 2008?...i already know how to control access as database but excel is I dont know...pls help me guys...I already searched at google but google can't answer my question...pls help!
This is what your after mate How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
Good luck ( I hate DB stuff :/ )
Joy4hacks (04-13-2013)