How can i connect to microsoft excel workbook so that i can insert, update and delete data from my program
i am using microsoft .net framework 1.1
How to connect to microsoft excel workbook?
Hot Topic
- FileInfo.CreationTime resolution
- Covert String or Object to Hex
- Can this be made more efficient?
- Does c# transaction include SQL After trigger?
- Could I "inlcude" a C# source file?
- question about arrays
- question about arrays
- How to Display Image From Byte
- UserControl Events
- Please read This!!! Buttons question
Visual C#
- XMLTextReader
- Bug with SplitContainer Continued IE Functionality from Previous Post
- Having troubles with Randomness
- Where does the compiled output for a web service go?
- Subclassing controls
- how to use trimend
- byte to integer conversion - client server programming
- Locating an .exe's path
- Error during reflection - dependancy not found
- datagridview selection and column span
How to connect to microsoft excel workbook?
christophilus
Yes your right there. The Jey Provider only retrieves data. If you want to modify the source then I suggest to access the excel worksheet via VSTO (Visual studio tools for Office) or use the PIA(Primary Interop Assembly) for Office and lastly you can access it via COM objects.
Here is a useful link that might help you: http://support.microsoft.com/kb/q301982/
cheers,
Paul June A. Domag
g4rc
Check out the following KB Article:
http://support.microsoft.com/default.aspx scid=kb;EN-US;316934
Regards,
Vikram
Marcus Taylor
jet ole db provider. So is there any alternative so that i can use delete operation on the records