Hi Folks,
Ok, solved this! It seems to be a case of not seeing the obvious because of
the obscure! There are in fact two dates on each row, one was being set to
Null, and the other to today's date, the problem was that the date was using a
format of "d/mmm/yyyy" whereas the Excel column was set to a format of
"dd/mm/yyyy".
Ian
----- Original Message -----
From: Ian Brooke
To: vbhelp
Sent: Sunday, December 05, 2004 7:56 AM
Subject: Re: [vbhelp] Excel & ADO
Hi Shawn,
I hadn't, but I have now. It gives an error "Multiple step operation
generated errors. Check each status value". This error happens on the
assignment statement but the other error that I mentioned actually happens on
the next statement to affect the recordset (ie the next MoveNext or Update)
which suggests it was happy to assign Null to the field and indeed using Null
had updated 1 row but for some reason didn't want to move on to another.
Baffled.
Regards
Ian
ps How's life in CA? I hope it is an improvement over Chicago.
----- Original Message -----
From: Shawn K. Hall
To: [EMAIL PROTECTED]
Sent: Saturday, December 04, 2004 10:32 PM
Subject: RE: [vbhelp] Excel & ADO
Hi Ian,
> ...Excel workbook contains a date but ...no date is
> available and the field has to be empty. I have
> tried putting all sorts of values...
Have you tried a single apostrophe ("'")?
Regards,
Shawn K. Hall
http://ReliableAnswers.com/
[Non-text portions of this message have been removed]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Sponsor
ADVERTISEMENT
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
