Luc,
You should be able to export your Access data into excel spreadsheets . I have imported a great deal of data via file gateway for a client in Mexico that uses your date format without any problems using excel spreadsheets. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: Monday, November 08, 2010 1:48 PM 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.
