My auditor wants me to export files from my AS/400 to MS Access and I don’t have a clue how to do that or if it can be done. I hope someone does.
Answer Question | June 29, 2010 7:00 PM
AS/400 import/export, export file, iSeries, MS Access
We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.
Answer Question | August 18, 2009 9:47 PM
AS/400 CSV, AS/400 import/export, CSV format, OS/400, V5R1, write csv file AS400
Hi, i need to write an RPGLE program to convert an as400 physical file to an xml file. Does anyone have a sample code for it? Thanks in advance.
Answer Question | July 2, 2009 5:10 AM
AS/400 import/export, Physical File, RPG/400, RPGLE, XML
I want to generate excle on server and store. I had copied spl file to pf but how can i generate excle on server.
Answer Question | June 26, 2009 11:31 AM
AS/400 backup, AS/400 import/export, Microsoft Excel
is there an addon that allows data to be sent back and forth excel to as400
Answer Question | June 5, 2009 9:50 PM
AS/400 import/export, AS/400 utilities, Microsoft Excel
I would like to know how can I achieve this ? and I am working on V4R4. Example : PF1 contains 100 records , I need to convert this into Exces .
Answer Question | May 11, 2009 6:24 AM
AS/400 import/export, CPYTOIMPF, CPYTOIMPF performance, iSeries import/export, Physical File, V4R4
I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.
Answer Question | May 7, 2009 7:26 PM
AS/400 Data Reports, AS/400 database, AS/400 import/export
In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client’s AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible. How [...]
Answer Question | April 21, 2009 8:11 AM
AS/400 import/export, Microsoft Access, Microsoft Access import/export
Hello, could someone suggest me an appropriate tool for AS/400 to Java migration? also, I am more interested if that is a product and not a service.
Answer Question | April 15, 2009 4:54 AM
AS/400, AS/400 development, AS/400 import/export, AS/400 migration, Java, Java Web developers, RPG
I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open [...]
Answer Question | April 14, 2009 6:15 AM
AS/400 import/export, CSV format, IFS Folder, RPG/400, RPGLE
Any one tell me using BRMS how to save the library while it’s in active stage.
Answer Question | August 5, 2009 9:27 AM
AS/400 backup, AS/400 import/export, Backup Recovery and Media Services, BRMS, Mainframe, SAP backup, SAP Import/Export
Hi, If I remember correctly thare is an iseries command to convert a file to .csv with the OS environment. Can anyone remember it. Not using Client Access. Thanks.
Answer Question | March 12, 2009 4:41 AM
AS/400 import/export, CSV format
Hello there, I’m hoping somebody can point me in the right direction. I need a 3rd party software which will be able to integrate with the AS400 to download 4 files & then convert them into .CSV files. This software will then need to save the exported data files to a server on our network. [...]
Answer Question | February 16, 2009 1:27 AM
AS/400 3rd party tools, AS/400 administration, AS/400 import/export, CSV file format
Hello Friends, I have a question. In my current project, I have to covert a spool file to notepad and this notepad I have to send it as an attachment to one email address. Question 1: How can I convert spool file to notepad? Question 2: How can I send a notepad as attachment to [...]
Answer Question | January 27, 2009 8:54 AM
AS/400 import/export, CL, CL/400, Spool files
Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).
Answer Question | September 25, 2009 8:11 AM
AS/400 administration, AS/400 import/export, Comma Separated Values, CSV file format, IFS, V4R3
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege [‘Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.
Answer Question | January 26, 2009 7:58 AM
AS/400 administration, AS/400 error messages, AS/400 import/export, Microsoft Excel, Microsoft Excel import/export
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in [...]
Answer Question | January 22, 2009 5:09 AM
5250 session, AS/400, AS/400 import/export, CCSID, Change Physical File, CHGPF, Coded Character Set Identifier, DDS, iSeries Access for Windows, locale, Microsoft Excel, Physical File, QMQRY, Query Management Query, V5R3
how to export as400 physical file to excel
Answer Question | January 12, 2009 1:45 AM
AS/400 import/export, Microsoft Excel, Physical File
Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,
Answer Question | January 9, 2009 7:57 PM
AS/400 import/export, AS/400 queries, CL programming, Exporting AS/400 to Excel, Microsoft Excel, Microsoft Excel import/export
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question | January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job