[RBASE-L] - re: importing table problem

[Luc Delcoigne]

Same problem with the excell-conversion.

DDMMYYYY is imported as MMDDYYYY.



;-)
  ----- Original Message ----- 
  From: Luc Delcoigne 
  To: RBASE-L Mailing List 
  Sent: Tuesday, November 09, 2010 10:31 AM
  Subject: [RBASE-L] - re: importing table problem


  Thanks Tony, 

  Right now I'm trying to convert via the Excell-sheet.
  Curious if that would work....

  Luc D.
    ----- Original Message ----- 
    From: A.G. IJntema 
    To: RBASE-L Mailing List 
    Sent: Tuesday, November 09, 2010 10:21 AM
    Subject: [RBASE-L] - re: importing table problem


    Luc,

     

    I am not familiar with all the details, but maybe it is an idea to attach 
all tables as is to the database (make a backup before!).

    Then you have to write some conversion procedures.

    You extract the date and time portion with functions like 
(DEXTRACT(datetime))

    I am aware it does not help you for now, but an important lesson I have 
learned in the past is to start with the conversion when you have to rebuild a 
system. Not only for this kind of details but also you will find hidden know 
how, when you analyze the content  of the old tables.

     

    I hope this helps a bit.

     

    Tony

     

    From: rbase-l@rbase.com [mailto:rbas...@rbase.com] On Behalf Of Luc 
Delcoigne
    Sent: dinsdag 9 november 2010 9:51
    To: RBASE-L Mailing List
    Subject: [RBASE-L] - re: importing table problem

     

    Razzak, 

     

    I have tried the ODBC migration .......however I get the message " Cannot 
Attach a DATETIME column to existing Consultdate of Type DATE"...

     

     

    It seems that the date and time columns in Access are really a DATETIME 
field, which seems to be different from the Rbase Date And Time fields.

     

    So the import works but all the date and time fields are left blank in the 
Rbase table....

     

    How can I solve this annoying problem ??

     

    Luc D.