If the DATETIME format in the source data file is MM/DD/YY HH:MM, then change the R:Base date and time formats accordingly (SET DATE FORMAT MM/DD/YY, and SET TIME FORMAT HH:MM) before loading.
After successful loading, change the R:Base date and time formats back to what you had, if needed. Stan Loo ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 4:41 PM Subject: [RBASE-L] - Re: Loading data into datetime field - Razzak'sReply > 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 >
