Hi Ed,
You definitely will not be the first one encountering this problem. I some way Excel is able to ruin the date values. The quickest way to solve this problem is to save the spreadsheet as txt (or csv) file. Then you can load this file. Please check with Notepad if your date values have been saved correctly Most probably all your problem will have gone Kind Regards, Tony IJntema Control, ICT en Operations BV Wijhe The Netherlands From: [email protected] [mailto:[email protected]] On Behalf Of Ed Rivkin Sent: zondag 16 augustus 2009 3:00 To: RBASE-L Mailing List Subject: [RBASE-L] - Problems using Gateway to Import Excel Hi folks, I am having two problems with Gateway Import. Couldn't find anything in the archives or Edge articles so I am again seeking your expertise. a) The file imports fine with interactive setup initially with File Import/Export button and subsequent use of the wizard. Unfortunately the three date columns are importing as null values. Text, Integers, and Currency cells map just fine. Looking at the spreadsheet date format, it is displayed as M/D/YYYY with no leading zeros. Changing the spreadsheet format to MM/DD/YYYY yields the same result. I have tried changing the date sequence in R:Base config settings and get similar results. The Wizard date settings are "MDY" date order, Four Digit Years is checked, Date Delimiter is "/", and Leading Zeros in dates is unchecked. b) My second problem is that I tried executing the Gateway Import from the R> prompt. I eventually want to imbed the import in a .rmd file. When I try executing the import at the R> prompt, the error message, "Please Select Import Mode!" appears. I am fairly confident the spreadsheet was created in Excel but I only have Open Office installed on my machine. Thanks as always, Ed __________ Informatie van ESET NOD32 Antivirus, versie van database viruskenmerken 4339 (20090816) __________ Het bericht is gecontroleerd door ESET NOD32 Antivirus. http://www.eset.com
