Well, in fact one can save a .csv file with a custom reformatted column, it just takes a few MS convoluted minutes, save as, are you sure?, exit, do you want to save? Formatting will be lost, OK anyway, file already exist, save anyway... And it now loads clean as a whistle... Perseverance pays... ~Claudine :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Claudine Robbins Sent: Wednesday, February 12, 2003 8:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Loading data into datetime field - Razzak'sReply Albert, Alastair, Stan, Dan, I originally exported datetime fields to .csv from oracle (there are no thousands of seconds). The datetime fields are formatted as "general format" when I open the csv file in Excel. Changing them to formatted "custom: mm/dd/yyyy hh:mm" can only be done if the file is saved as .xls. But I can't load an .xls file into Rbase... Some of the tables import correctly from the .csv files some don't. I'll have to put on my detective cap to see why not. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Goldberg Sent: Wednesday, February 12, 2003 3:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Loading data into datetime field - Razzak'sReply Are you importing a datetime format or just date format?? Dan Goldberg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Claudine Robbins Sent: Wednesday, February 12, 2003 1:41 PM To: RBASE-L Mailing List 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
