Mike, In looking at the CSV file, the date is stored as 20 Jan 2009. Now what, can we handle this?
Thanks, Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Wednesday, November 18, 2009 10:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Problem Importing an Excel File with File Gateway Why don't you export a small sample from excel to a CSV and see how the format is actually arranged first. ----- Original Message ----- From: "Paul Buckley" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, November 18, 2009 10:04 AM Subject: [RBASE-L] - Problem Importing an Excel File with File Gateway > Can I get someone else to confirm this before I submit it to RBTI? I'm > trying to import an Excel XLS file using File Gateway in eXtreme 9.0, ver. > 9.0.1.11111. The Excel file has a date column and the dates are entered > as > mm/dd/yyyy but formatted to display as 'day month year' (i.e. 20 Jan > 2009) > . I have changed the gateway setting to DMY but the date data does not > import (actually tried all options for format). If I change the format of > the Excel column to mm/dd/yyyy it imports correctly. > > > > Could someone please test this for me before I submit it? It's very > likely > I'm just missing something. I've also tried this in the latest V8 build > and > get the same results. > > > > Thanks in advance, > > Paul Buckley > > > >
