Re: ADO Excel D2007 SQL UPDATE problem

I tried disconnecting and reconnecting. It made no difference - I have the same EOleException.
Sven

"Sven Pran" <no.direct@xxxxxxxxxxx> wrote in message news:480b99a1$1@xxxxxxxxxxxxxxxxxxxxxxxxx
I am successfully connecting to an Excel workbook and perform some actions related to selected records.

Then I want to update one field in those records that have been processed.

To do this I ended up closing the ADODataset, changing the SELECT statement to an UPDATE statement and then open the ADODataset again.

This results in the following EOleException: 'Current provider does not support returning multiple recordsets from a single execution' .

Here is the UPDATE statement I am trying:
UPDATE Fakturering SET Fakturert =2008-04-20 WHERE Fakturering.Fakturert IS NULL AND Fakturering.KNr = 1623

I am not too happy about disconnecting completely from the workbook while doing this job, but is that the problem? Do I have to disconnect and reconnect in addition to close and open my ADODataset or is there something else I am doing wrong?

I cannot remember having had such problems when working with Access databases through ADO, but as i am fairly new to ADO with Excel I shall be most grateful for any advice.

regards Sven

.

Relevant Pages

  • Strange PPPoE behaviour -- Need help to avoid fees
    ... I just got a call from my ISP telling me that my DSL has been ... disconnecting and reconnecting every 3 minutes for the past few months, ...
    (freebsd-questions)
  • Re: Connecting to TS Server
    ... Why are they disconnecting and then immediately reconnecting? ... user at a remote site logs out and then immediately tries to reconnect ... problems connecting both thin clients to TS. ...
    (microsoft.public.windows.terminal_services)
  • Re: FYI: TrueCrypt 4.2 ist da
    ... | It is now possible to dismount volumes that cannot be opened ... after disconnecting and reconnecting a USB flash ...
    (de.comp.security.misc)
  • Re: question on odd APIC behavior
    ... same rate, disconnecting the device on the bus stops the increase, ... reconnecting it makes them increase again. ... Very odd indeed. ...
    (Linux-Kernel)
  • Re: Strange PPPoE behaviour -- Need help to avoid fees
    ... > I just got a call from my ISP telling me that my DSL has been ... > disconnecting and reconnecting every 3 minutes for the past few months, ...
    (freebsd-questions)