Re: Excel Add-in after ACS install

Bryan,

That option well for me.
I have excel templates using the Excel Data Connection Wizard with
customized sql statements.
Open excel - it auto brings the data into excel from the iSeries, pretty
slick actually.
I found I had trouble with the customized sql statement from iAccess so
using the Excel Wizard was a good option.

Diane



From: Bryan Dietz <bdietz400@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/24/2016 03:05 PM
Subject: Re: Excel Add-in after ACS install



As an alternate way to get data into excel...

I've used the Excel Data connection wizard;
(this assumes you have loaded the windows part of the ACS client for the
ODBC driver)
[Data]
[Get external data]
[from other sources]
[from data connection wizard]
[ODBC DSN] <next>
[pick a DSN connection]

Then pick files for connection

you can save the data connection so it can be recalled later

When you get to the "import data" window you can click <properties>
then definition, and if you have specific SQL statements they can be
entered here.

Lots of other stuff you can customize.

I'm prettey sure this existed before, but I found it a simple(?) way to
get data to the XLS without "leaving" excel.
I know the data transfer program can also utilize SQL selection



Bryan


Charles Wilt wrote on 5/24/2016 2:51 PM:

found an article that talks about ACS' ability to transfer data from the
active spreadsheet instead of having a separately installable plug-in.

http://iprodeveloper.com/blog/move-your-data-access-client-solutions

Didn't seem to pick up the ending cell in my highlighted range. And it

was

kind of a PITA to have to jump out of Excel to start the data transfer.
Lastly, I had to figure out to invoke the "Actions->Create IBM Database
file" wizard prior to the transfer rather than automatically as part of

it.

But the data's on my i, so mission accomplished.

Charles


On Tue, May 24, 2016 at 2:28 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

Does the new ACS client software include an Excel add-in like iAccess

for

Windows did?

Is it part of the the platform independent package or the platform
dependent one?

My previously working data transfer add-ins have stopped working.

But I've recently moved to the new ACS client. I'm thinking there's an
issue there.

Charles