Excel as an database

[Khozema Sherwala]

Hi,

I would like to know that, Is it possible to use Excel sheet as a source
(dataset) and use it against a .net client application (VB.NET) and have all
CRUD operation on data. The excel data will have one key column which will be
used as identifier. I am wondering whether is this possible.

If Yes, any pointer in that direction and how to implement required code
base using libraries will be of great help. Thanks!

regards,
Sherwala

 

[Simon Murphy]

Yes - use the ADO Jet drivers
VB code here
http://support.microsoft.com/kb/257819
Its easy to adapt to VB.net/C# - the workbook needs to be closed
otherwise you'll leak a ton of memory

Cheers
Simon
Excel development website: www.codematic.net

 

[Khozema Sherwala]

Thanks Simon. This does helped a lot

Yes - use the ADO Jet drivers
VB code here
http://support.microsoft.com/kb/257819
Its easy to adapt to VB.net/C# - the workbook needs to be closed
otherwise you'll leak a ton of memory

Cheers
Simon
Excel development website: www.codematic.net