Re: Downloading Date Fields to Excel

["Michael Naughton" <mnaughton@xxxxxxxxxxxx>]

For the archives, here's a quick update, since no one else has replied
with anything better. I haven't found anything that works when I transter
the file into Excel directly, but if I transfer it into a .CSV file, with
dates as character fields formatted either mm/dd/yy or mm/dd/yyyy, and
then open it in Excel, the dates work fine. It seems a little hokey, but
it'll probably work for what I'm doing.

One down side is that I lose all the field names as column headers. I
could fix that with Excel macros, but since I have total control over the
file being downloaded (it's a work file built by my program), I'm trying
something else: I've made all the fields in the file character, and I load
my field names into the first record. So far, this seems to be a pretty
good approach. (A little labor-intensive, though :-).

I don't know how many other people are having this problem, but given what
appears to be an increasing trend towards integration of different systems
this seems like an Opportunity for Improvement for IBM. . . .

Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:
> see from the archives that last June Peter Dow had the same problem that
>I'm having, but I didn't see that he got an answer. I've got a file on my
>AS/400 that contains some date fields, and I'm trying to use the Client
>Access file transfer to download it into Excel. The transfer wizard
>recognizes the fields as date fields, but they end up in the spreadsheet
>as alpha fields. However, if I simply edit one without changing anything,
>it magically transforms itself into a date.
>
>Is there any way to get the transfer to produce dates without going
>through this step?  Thanks very much!
>
>Mike Naughton


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx