• AS/400 addon for Microsoft Excel

    is there an addon that allows data to be sent back and forth excel to as400

    Glenc15 pointsBadges:
  • 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 .

    Chrisjam95 pointsBadges:
  • 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.

    Gordon245 pointsBadges:
  • 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....

    JEV5 pointsBadges:
  • 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.

    Suc10 pointsBadges:
  • 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 the .CSV files...

    Richapd5 pointsBadges:
  • Data transfer from EXCEL using AS400 add-in to AS400 physical file

    If EXCEL is the starting point, how can I make the user specify the file name to transfer the EXCEL info to. Or how can I lock a predetermined file until after the transfer is complete? Thanks in advance

    BobK5 pointsBadges:
  • 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.

    tjgm88995 pointsBadges:
  • copy pdf files from an E drive into an AS/400 data file

    Is there a way to copy pdf files directly into an AS/400 data file?

    MountHood5 pointsBadges:
  • 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. The...

    Smeakin5 pointsBadges:
  • 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 one email address?...

    BibinGeorge130 pointsBadges:
  • 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.

    NADEE12320 pointsBadges:
  • 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 these DB files...

    Proturborandza25 pointsBadges:
  • How to export an AS/400 physical file to Microsoft Excel?

    how to export as400 physical file to excel

    Reskind5 pointsBadges:
  • 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.

    Querys100 pointsBadges:
  • Copy data from flat file to a flat file

    My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

    Supriyob2165 pointsBadges:
  • Is it possible to get a PDF from AS400 spool file?

    Is this possible? Is it really possible to get a PDF from spool file? Nothing seems to work. :-( I was trying to convert PDF in iSeries Navigator. I put a spool file, right click, convert to pdf, asks me whether I want a new printer, I say yes, starts a printer then a writer but then everything...

    Avrelivs80 pointsBadges:
  • auto transfer of as400 to pc

    Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help

    Nikolai196030 pointsBadges:
  • Excel Imported Data

    Import data from an AS400 using the query function in XL. Hangs. Connection is ok, finds the tables but when it tries to retrieve records an write to XL work sheet it just hangs. Can anyone help. I believe it is a job on the AS400, but which one?

    MECA15 pointsBadges:
  • Transferring files from AS/400 to Sharepoint 3

    We want to be able to transfer data files (Excel Spreadsheets) from our AS/400 to a Sharepoint site. We've been advised that e-mail is a solution, but for security reasons our company won't allow this. We have a utility that let's us create the Excel files on the AS/400 but cannot work out what's...

    Debu66er5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following