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]
------------------------ 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/
