I think Peter's response (I already tried it) does the trick.

Also, I told the users I could easily do this job fully on the i5, but
currently w/o the GUI part of it. They were not sure what to say, so I
suggested they try to run it as a stand alone system, and make the
manual changes as needed.

I believe they will gain great insights into the importance of
system/database integration once they do so.

In fairness, I also told them I would see what kind of i5 to Excel
"integration" solutions are available.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, September 17, 2008 1:17 PM
To: Midrange Systems Technical Discussion
Subject: Re: Getting AS/400 Data to Link Real-Time to Excel

You mean like a trigger program against a database tied into the API's
to write directly to excel? No trigger programs here doing that yet
(that I know of). We are doing lots of wrinting directly into Excel
files though.

Rob Berendt
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755

"Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/17/2008 01:30 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

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

Getting AS/400 Data to Link Real-Time to Excel

Anyone doing this now? Where an updated record on the i5, will be
in the spreadsheet, AND deleted i5 records will be deleted from excel,
added i5 records will be added to excel?

Don F. Cavaiani
IT Manager
Amerequip Corp.

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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].