The problem with Excel (especially the European date setting) is that what you see is not what you receive. I have had this problem many times before.
Can you send me in private a small example database or excel sheet, maybe I can find another solution Tony From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: dinsdag 9 november 2010 10:36 To: RBASE-L Mailing List Subject: [RBASE-L] - re: importing table problem Same problem with the excell-conversion. DDMMYYYY is imported as MMDDYYYY. ;-) ----- Original Message ----- From: Luc Delcoigne <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> 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 <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> 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: [email protected] [mailto:[email protected]] 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.
