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
