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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
