• 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:
  • Update excel charts auto from as400 data

    I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in excel & then copy data to graph excel...

    Gerrib150 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