RE: iSeries Access Excell add-in: Windows 10, Office 16 64-bit

How about back up to an empty file from that excel spreadsheet? We have been receiving, NOT CSV, but actual XLSX files. (PITA)

We get these as one offs but still need to upload to a database file for processing.


Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Steinmetz, Paul via MIDRANGE-L
Sent: Thursday, October 3, 2019 8:44 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
Subject: RE: iSeries Access Excell add-in: Windows 10, Office 16 64-bit

Joe,

You no longer need the add-ins with ACS.
In ACS
Open a blank Excel (20160 in our case)
Transfer from IBM i
Change the Output device from file to Active Excel Spreadsheet.
Works great.

Also, ODBC driver no longer needed for this to work.

Paul