Question!

[TNewton]

Hello, I'm really new at this.
I work with an AS/400 system and I am trying to get a spreadsheet going that has all of our account's Fax numbers and Email addresses.
Basically the information in Cmnd CM50.
Is there a report that I can run that will provide all of that information?
And if so.. is there a way I could possibly convert it to excel?

Answers will be highly appreciated, thanks!

[jtemple]

Re: Question!

TNewton,

I'm assuming that you're referencing a command on your system called "CM50"? This is probably a command developed by the company that produced your software.

What you need to find out is what file is behind the command or program. Once you have that information, you can use Access or Excel with the proper ODBC driver configured to extract the data. Of course, you can also use FROG (http://www.innovativesys.net).

HTH

[BenThurley]

Re: Question!

Or you could use the "Data transfer from iSeries server" utility that comes with iSeries access. You would still need to know the file though.