Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can CrossData/400 create Excel files?

April 26, 2017create crossdata Excel files

0

Posted

Can CrossData/400 create Excel files?

1 Answer

0

Posted

Yes. CrossData/400 creates CSV (Comma Separated Values) files from your AS/400 database that can be directly imported to Microsoft Excel. Any file transferred to a PC that has an extension of .CSV and that conforms to the rules of CSV files are associated with the Excel application. A user who receives a CSV file can double-click on the file to launch Excel and load the file. Additionally, Excel spreadsheets can execute macros that load and manipulate CSV files created by CrossData/400. You can create CSV files from interactive panels, Application Program Interfaces, CrossData/400 commands, and from an existing IBM Query definition.