How to Transfer IBM i Data to Microsoft Excel
Business users have become very comfortable with (and some might even say dependent on) using Microsoft Excel to view, manipulate, and put data in visual graphs and charts for the business. But there’s a problem here for IBM i. Traditional IBM i data access tools—such as Query/400 or the Excel add-in for IBM i Access—don’t play nicely with Excel, which can create a headache for business users and IT teams.
There’s a good chance that you’ve run into broken Excel-to-IBM i data transfers more than once. IBM has released several kits and workarounds to address the issue over the years, but did you know there’s an easier, more reliable way to import your IBM i data to Excel? It’s called Sequel.
In this webinar, our data access expert will demonstrate how you can simplify the process of getting data from multiple sources—including Db2 for i—into Excel. Watch now and you’ll learn how to:
Download your IBM i data to Excel in a single step using Sequel
Deliver data to business users in Excel via email or a scheduled job
Access IBM i data directly using the Excel add-in in Sequel
#ibmi