CODEWITHSUNDEEP
db2ibm-midrange
Nicolas
Nicolas

Reputation: 45

Which is the best way to get the data from AS400 to Excel with specific fields?

We have a screen which has number of fields from different tables, i need to extract those fields from tables and keep the data in Excel sheet. How can i do this ?

Upvotes: 0

Views: 4477

Answers (2)

Mark Golden
Mark Golden

Reputation: 21

There is a tool called iEXL which will create .Xlsx spreadsheets native on the AS400. If you after only data from one screen we will help you and the price would we adjusted to take this into account.

WWW.iEXLSOFTWARE.COM

Upvotes: 1

Dave Ford
Dave Ford

Reputation: 363

Is this a "one-time" data-transfer, or will it be an ongoing, automated process?

IMHO, for a "one-time" data-extraction, the easiest way to accomplish that is using ODBC. Historically, I've used ODBC to import the data into Microsoft Access. From there, it's extremely easy to export the data into Excel.

For a regularly-occurring, automated method, I think using the CpyToImpF command works the best. It takes a little trial-and-error to get the process working, but once you've got it set up, it can run in regularly scheduled job to export the data. (Google the syntax for the command, and try it yourself.)

HTH, Dave

Upvotes: 2

Related Questions