Kwang, Thank you for the quick reply! I would like to follow your advice but I don't know how....I had the same error without the CreateODBCDate conversion tag and can find no docs on OLE date formats. Should I not be using CreateDate? ...... >You are using ODBC date formats for OLE DB, which does not support ODBC date formats. >You must use the native DB syntax for dates... -- Signature...... "In the best relationships sex is the booby prize." "I'm gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
