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
