Luc,
If Access stores a date value in the same way as Excel then you must be aware that what you see is not the way it is stored in Access Did you try to set the import setting to MMDDYYYY and MM/DD/YYYY Tony From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: maandag 8 november 2010 21:48 To: RBASE-L Mailing List Subject: [RBASE-L] - re: import problem Jan , I did a "show date seq" and I got the right DDMMYYYY. Strange... Luc From: jan <mailto:[email protected]> johansen Sent: Monday, November 08, 2010 9:40 PM To: RBASE-L <mailto:[email protected]> Mailing List Subject: [RBASE-L] - re: import problem Luc, Listen to Dennis! Mine was for the formating Jan -----Original Message----- From: Dennis McGrath <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 8 Nov 2010 14:35:58 -0600 Subject: [RBASE-L] - re: import problem Change DATE SEQ to DDMMYYYY before importing? Experiment Dennis McGrath _____ From: [email protected] [mailto: [email protected]] On Behalf Of Luc Delcoigne Sent: Monday, November 08, 2010 2:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - re: import problem Hi, I have begun to convert the data of my access database to RBase. in an Access table I have a date column in the format DD/MM/YYYY. When I import this table with the File Gateway, I get a format MM/DD/YYYY in the Rbase table for that same column, meaning that all dates higher than de 12th of a month are not imported as Rbase thinks it is month 13 where it should read day 13. What am I overlooking here ? Luc D.
