Is there any reason why you cant use rbases gateway command or menupick to import your XLS file. I have imported lots of data into my database this way.
----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 6:03 PM 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 > >
