One approach I have used with tricky imports from other sources - which included printing 5 Mb of text file to disk, and using fixed ascii to import it in 1990 - and sometimes all you can do is define a column as text in a temporary import table (could be permanent table, but the data is in there only temporarily.
As you no doubt know, R:Base will take a text argument in proper format and translate it to DATE. --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > > 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. > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
