RE: Accessing AS/400 data with Excel

[rob@xxxxxxxxx]

And how does that save their changes back to the 400?

I did Database, Get External Data, New Database Query.  But I think that is
kind of like a download.  I saw the refresh button.  Everytime I made a
change it got clobbered when I clicked on this button.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    "Art Tostaine, Jr."
                    <art@link400.com>         To:     <midrange-l@midrange.com>
                    Sent by:                  cc:
                    midrange-l-admin@mi       Fax to:
                    drange.com                Subject:     RE: Accessing AS/400 
data with Excel


                    03/21/2002 03:35 PM
                    Please respond to
                    midrange-l






With ODBC.  Excel Data Menu, Get External Data.

_________________
Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

> -----Original Message-----
> From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]On Behalf Of rob@dekko.com
> Sent: Thursday, March 21, 2002 3:30 PM
> To: midrange-l@midrange.com
> Subject: Accessing AS/400 data with Excel
> Isn't there a way to access AS/400 data directly with Excel?  I do NOT
mean
> download/upload.  If so, how?

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.