Hi Folks, I mentioned the other day that I had solved a speed problem trying to use the Excel object from VB6 by accessing the Excel Workbooks using ADO, it seems I spoke a little early! I now have a bit of a problem which I don't understand. The program is looping down the rows of a listview finding all the selected rows, and using those rows to update an ADO recordset. One of the columns in the listview, and in the Excel workbook contains a date but in some instances no date is available and the field has to be empty. I have tried putting all sorts of values into this recordset field (I've tried Null, VBNull, VBNullString, "", " ", etc) but nothing works (except a date!) but it must be possible because I can open the spreadsheet in Excel and clear the cell without problem. The error actually seems to happen on the next ADO command to access the recordset (it could be either a MoveNext or an Update) after setting this field to a none date value, and the error raised is "Selected collating sequence not supported by the Operating System". Does anyone have any ideas how to cure this? With thanks Ian
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
