Razzak, I changed the idquote to ` but still load nulls instead of datetime values, all other fields load correctly. Some tables load w/no error messages, others with "excess values will be ignored"... My load command is: LOAD DA_COMPANIES FROM D:\COMPANIES.CSV AS CSV ~Claudine :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A. Razzak Memon Sent: Wednesday, February 12, 2003 3:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Loading data into datetime field - Razzak'sReply Claudine, Check the database SETtings for QUOTES and IDQUOTES. CONNect dbname IDENTIFIED BY UserID Password SHOW CHAR Very Best Regards, Razzak. At 02:32 PM 2/12/2003 -0600, Claudine Robbins wrote: >I am struggling with loading data from a .csv file into a db table with >datetime fields. I am matching the format in RBase to the data in the >.csv file mm/dd/yyyy and hh:mm:ss but this setting and every variation >yields the same result: -0- in the field. And I know I have done this >successfully in the past... Any ideas? ~Claudine
