Re: Direct update to Excel spreadsheets

[MWalter@xxxxxxxxxxxxxxx]

Well you could have a program run on the iSeries that periodically  puts an
entry on a Data Queue. Then have your spreadsheet check for the entry in a
macro.  If it finds it then it updates the database. That way, TECHNICALLY,
the iSeries is initiating the transaction. To do it the other way, I'm
thinking you'd have to use an ODBC connection to the spreadsheet. That is
if an ODBC driver for Excel even exists for the iSeries. I don't know.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


|---------+------------------------------->
|         |           rob@xxxxxxxxx       |
|         |           Sent by:            |
|         |           midrange-l-bounces@m|
|         |           idrange.com         |
|         |                               |
|         |                               |
|         |           12/17/2003 01:29 PM |
|         |           Please respond to   |
|         |           Midrange Systems    |
|         |           Technical Discussion|
|         |                               |
|---------+------------------------------->
  
>------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                 |
  |       To:       Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>                                              |
  |       cc:                                                                   
                                                 |
  |       Subject:  Re: Direct update to Excel spreadsheets                     
                                                 |
  
>------------------------------------------------------------------------------------------------------------------------------|




Here's the deal.  Some program on the PC goes out and polls the PLC's.
Then takes this data and stores it into certain cells.  Perhaps PLC 001
quantity run goes into A4, PLC 021 quantity run goes into B4 and so on.

Anyway, the boss wants the iSeries to poll the PC, and not have the PC
initiate the transaction.  Perhaps this way the iSeries can control when
datafiles get updated.  Backups, period end, scheduled downtimes, that
sort of rot.

Rob Berendt
--
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.