Suggestion -
1. Setup the table with the columns defined before loading.
2. Use Gateway and select the date format when the parameter page is shown. This option is not available when loading to a new table.
3. When loading directly into a new table, you can select only a date definition. You would assume that if your settings specified ddmmyyyy then it should load properly, however, it may not be so.
4. As an alternative, I would save the Excel worksheet as a csv file. Then use the load command(table must be defined). This is much quicker in loading than Gateway. Check to see if the file loads correctly.
Gary
----- Original Message -----
From: "John Docherty" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, March 01, 2005 9:43 PM Subject: [RBG7-L] - Re: Date Conversion - Gateway
Razzak,
Thanks for your reply.
I am importing into a new table, and have the following settings:-
Date Input DDMMYYYY Default Century 20 Century threshold YEAR is 0
The second column in the spreadsheet is a date field (ie set the format to a
number and you get 38121 etc, set it to date you see 15/5/2004). I have
tried setting the B column in the new table to both DATE and NOTE types.
Can you please clarify your comment re how the column should be set in RBASE
- should it work with the column set to a DATE type ? (All the other
columns, which are just text, appear in the correct columns, as expected.)
Should I try pasting the date column as values in Excel and then import the
column as a TEXT field or should RBase do the conversion for me ?
Thanks for your assistance.
Regards,
John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, 2 March 2005 3:55 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Date Conversion - Gateway
At 09:21 PM 3/1/2005, John Docherty wrote:
I start with a date such as '14/5/2004' in the spreadsheet, where the column and cell have a date format, and I end up with 38121 (note), or a null (date), in my RBase 'date' column. Not quite what I wanted.
John,
Are you importing the data into a *new* table or existing table?
FYI, R:BASE column defined as DATE, will NOT accept the data as NOTE. You'll have to check the table structure and column sequence.
Does the existing table structure (column sequence and data types) match the cell sequence and data type of XLS spreadsheet?
What are the DATE FORMAT, DATE SEQUENCE, DATE YEAR and DATE CENTURY settings of your database?
I suggest you re-visit the table structure vs. XLS structure and then use the GATEWAY IMPORT option to import
Very Best R:egards,
Razzak.
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.5.5 - Release Date: 1/03/2005
