Re: Best Way to get Excel data to AS/400 -- MIDRANGE-L

Subject: Re: Best Way to get Excel data to AS/400
From: MWalter@xxxxxxxxxxxxxxx
Date: Wed, 24 Jul 2002 16:41:48 -0400
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=unsubscribe>

We use the same TCP/IP client and the file transfers work fine. Just select
an excel file type on the transfer. And be sure to convert CCSID 65535 or
your alpha fields will come in as hex. If you have Excel 97 and Client
Access Express, there should be a 'Get AS/400 Data' option under the
Data-->Get External Data menu option. It went away when I upgraded to
Office 2000. If there is anyone out there who can help me get it back, I
would be very appreciative.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Best Way to get Excel data to AS/400 , Vernon Hamberg

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.