RE: Excel Add-ons

I wish that you would have opened a case with IBM about that truncation.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of dmmueller@xxxxxxx
Sent: Wednesday, March 27, 2019 1:42 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: 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.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com