Atul, If I understand your statement correctly, you know how to export data from MAPICS to Excel, so your problem is in exporting IMHIST file. You can not export the complete file of IMHIST, this is because there is a field in IMHIST called TKEN(Token), which is not understood by Excel. So, you need to create a simple query using IMHIST after excluding the TKEN field, and output into a temporary file and then down load the temporary file into Excel. You can use either 'Data Transfer from iSeries' tool or Excel Add-Ins 'Client Access Data Transfer'. Regards, S.P. Selvaraj Senior I.T. Specialist, Asia Pacific Tel. Dir (65) 6586-8009, Mobile (65) 9653-4048, IP Phone 4368 The information contained in this message, and any attachments, are or may be privileged and/or confidential and protected from disclosure and may also be covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. If the recipient of this message is not the intended recipient or authorized to receive this information for the addressee, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error please delete it from your computer immediately. atul beedu <a_beedu@xxxxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 07/21/2005 04:27 AM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To mapics-l@xxxxxxxxxxxx cc Subject INVENTORY HISTORY FILES EXPORT TO EXCEL Is there any way to export Inventory transaction history files from mapics to excel?.I have exported the imhist and itembal files out but not been able to export the inv trans hist for a partcular components. i want to push these files into a Foxpro database. Uptil now i am exporting them from the mapics browser to excel, this is not effecient while dealing with many components, i hope to automate this. Any help would be greatly appreciated. regards Atul Beedu ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.