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.
