Export AS/400 to MS Access
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
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 runing V5R1 OS400, how do I write to CSV file
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
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
AS400 Physical file conversion to xml file
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
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
generating excel on server
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
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
AS/400 addon for 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
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
How can I convert all the records from a Physical File to Exces ?
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 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 not a programmer
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
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
AS/400 data to Microsoft Access database
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
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
AS/400 to Java migration
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
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
How to automate getting the .CSV file from IFS folder to local desktop
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
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
BRMS – Save from AS/400 to Mainframe, then Mainframe to SAP
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
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
AS/400 command to convert a file to .csv
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
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
Need a 3rd party AS/400 utility for converting to .CSV files
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 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
CL/400 – How to convert Spool file to Notepad
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
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
Create .csv file on IFS folder in AS/400
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
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
How to export data from AS/400 into Microsoft Excel
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
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
Problem in CCSID converting
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
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 an AS/400 physical file to Microsoft Excel?
how to export as400 physical file to excel
Answer Question
| January 12, 2009 1:45 AM
AS/400 import/export, Microsoft Excel, Physical File
how to export as400 physical file to excel
Answer Question
| January 12, 2009 1:45 AM
AS/400 import/export, Microsoft Excel, Physical File
CL Program
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
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
AS400/iSeries Queries on a schedule
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
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
