RE: Write to iSeries via ODBC

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Guy Terry
Sent: Tuesday, November 13, 2007 5:09 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Write to iSeries via ODBC

Alas, I still can't make it work. I use MS Query to get the
file into Excel, change the value of one of the cells and hit
Refresh. The value simply gets over-written to what it was originally.

Of course it does, refresh means refresh the data from the original source.

You're not linking to the data, you're just importing it.

AFAIK, the only way (besides a VBA procedure) to get the data back to the iSeries from Excel is with
the "Transfer data to iSeries" plugin which uses the iSeries Access Data transfer utility.

Note that if you're simply doing a SELECT * from MYFILE in MS Query, then you might find it easier to
use the "Transfer data from iSeries" as that will build the .FDF file you'll need to use for the
Transfer data to iSeries".

If you're not simply pulling an entire file, then you're going to have a more difficult time getting
the data back from Excel. The task may not be possible without a VBA procedure.

"Transfer data to/from iSeries" should appear under the Data menu. If not, look in the archives and
or IBM KB as there's instructions on how to get them to show up.

Charles


This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.