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

--

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.