|
For simple downloads from the AS400 to Word or Excel I have installed a product called Winspool for several clients. It is a Windows based GUI that looks at either OUTQ's or users spooled files. A simple mouse click then downloads it to the desktop, and will open the file in multiple formats such as Word, Excel, PDF, HTML, txt, etc..It also had a tool with it called Data Import that let you format a report, strip out headings, select/omit fields/columns and save that definition as a 'mask'. Winspool can use that mask when downloading to format reports. Masks can be shared on the network. Pretty cheap too, I think around $1,500 bucks, unlimited users on the same Lpar.RJS Software is the vendor, they have many cool AS/400 and Windows based utilities. Jim -----Original Message----- From: bpcs-l-bounces+jmergen=pctcnet.net@xxxxxxxxxxxx [mailto:bpcs-l-bounces+jmergen=pctcnet.net@xxxxxxxxxxxx]On Behalf Of Dennis Basiner Sent: Thursday, May 18, 2006 8:19 AM To: BPCS MIDRANGE Subject: [BPCS-L] BPCS reports Does anyone know of an inexpensive way to convert a BPCS report to an EXCEL spreadsheet ? Don't get enough requests to invest in expensive software but every time someone requests it, it's a challenge. Any recommendations would be greatly appreciated. Regards, Dennis Basiner Information Systems Manager Cains Foods L.P. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: Wednesday, May 17, 2006 -- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: jmergen@xxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.