RE: Excel Add-ons

Just configured my new pc using Office 2019. (Windows 10 64 bit) I
thought I would try the ACS feature with the transfer option, although I
have somewhat of a complex SQL statement. I ran it and it worked, but
when I tried to "save" the transfer.
The save was truncating my statement, only keeping the last line of the
where clause.
After several retries of the save, I decided to scratch that, and go back
to my IBMDA400 OLE connection.
I simply copied the data sources from the old pc to the new pc that is now
running Office 2019 and ran the excel transfer. Initially it bombed, but
then realized my new pc did not have the ODBC drivers installed. Once
those were added, my excel transfer worked immediately.

I do not have the excel add-in, only using the IBMDA400 as the data
source.

Diane Mueller




From: "Justin Taylor" <JUSTIN@xxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 03/27/2019 12:06 PM
Subject: RE: Excel Add-ons



ODBC is in the "Optional platform-specific packages" for Windows or Linux.
I assume the Excel add-in is included in the Windows version.
https://www-01.ibm.com/support/docview.wss?uid=isg3T1026805



-----Original Message-----
From: Christopher Bipes [mailto:chris.bipes@xxxxxxxxxxxxxxx]
Sent: Wednesday, March 27, 2019 10:44 AM
To: 'midrange-l@xxxxxxxxxxxxxxxxxx' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Excel Add-ons

If I only have the JAVA IBM i Access installed, where would I find the
ODBC drivers as well as the Excel add on to retrieve data directly from
our iSeries?

Chris Bipes
Director of Information Services
CrossCheck, Inc.