AS/400 import/export Questions


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
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
55 pts.

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
asked by:
15 pts.

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
asked by:
15 pts.

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
asked by:
95 pts.

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
asked by:
5 pts.

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
asked by:
JEV
5 pts.

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
asked by:
Suc
10 pts.

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
asked by:
5 pts.

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
asked by:
130 pts.

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
asked by:
980 pts.

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
asked by:
5 pts.

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
asked by:
130 pts.

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
asked by:
160 pts.

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
asked by:
20 pts.

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
asked by:
25 pts.

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
asked by:
5 pts.

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
asked by:
100 pts.

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
asked by:
100 pts.