Re: Excel using ado.net - operation must use an updateable query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 11/22/04 

Date: 22 Nov 2004 01:43:55 -0800

"vvenk" <vvenk@discussions.microsoft.com> wrote ...

> I don't think you can update an Excel *** using OLEDB (also a text file).
> That's why yo get the message "operation must use an updateable query"

You are mistaken: it is indeed possible to update an Excel sheets and
a text files using OLE DB.

Jamie. 

--
Quantcast