Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database | Excel Programming | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming |