RE: Automating downloading an Excel spread sheet to the iSeries using a macro

[Nick_Radich@xxxxxxxxxxxxxx]

We use 2 products from KEMETECH called CVTXLSDBF and CVTDBFXLS to transfer 
data back and forth from Excel and the AS/400.  It is very easy to use and 
is not expensive.

HTH,

Nick


Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct  (320) 679-6683
Toll free  (800) 388-2155  ext. 6683
Fax  (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



"Chavez, Rene \(NBC Universal\)" <rene.chavez@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/10/06 10:48 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Automating downloading an Excel spread sheet to the iSeries using   a 
macro






Thank you for the tip, but I have used this process, successfully, in the 
past.
What I was looking for was a process that would allow the user to send 
data from an Excel 
spread sheet to the iSeries via a macro.
In other words, to automate the data transfer process once the user has 
finished entering
his data into his spread sheet.

Thanks again,   Rene

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Pat Barber
Sent: Wednesday, May 10, 2006 6:52 AM
To: Midrange Systems Technical Discussion
Subject: Re: Automating downloading an Excel spread sheet to the iSeries
usinga macro


This is has been handled as a "add on" to Client Access for a
number of years. It's free and easy to handle.

http://www-912.ibm.com/s_dir/slkbase.nsf/1ac66549a21402188625680b0002037e/5305eddb9ee075b886256e86005928a8?OpenDocument&ExpandSection=-1&Highlight=0,Excel#_Section1





Chavez, Rene (NBC Universal) wrote:

>>I have been given a project to accomplish the above.
>>I can't seem to get a straight approach from anyone, 
>>Can you help.
>>
>>Thanks in advance,  Rene
> 
>