Excel as an database
 

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

Excel as an database
 

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 wrote:
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

Excel as an database
 

Thanks Simon. This does helped a lot

"Simon Murphy" wrote:

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 wrote:
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