Claudine - have you tried loading to separate date and time fields? Sometimes the system takes a space as a delimiter on a load like this.
"Claudine Robbins" <[EMAIL PROTECTED]> wrote: >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 > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
