Had option #2 not worked for me, I definitely would have.
Actually, using this option works best for me since I have additional
macros built into the excel file.
With the ACS issue, I assumed there is sometime of character limitation on
the select clause, and since this is somewhat complex, I just assumed I
was hitting the max characters.
Diane
From: "Rob Berendt" <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 03/27/2019 12:47 PM
Subject: 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
midrange.com
