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

Rob,

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.

Don

-----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
http://www.dekko.com





"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>


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

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







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

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

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