How can I convert all the records from a Physical File to Exces ?
Home > IT Answers > AS/400 > How can I convert all the records from a Phys...
Chrisjam
95 pts.
0
Q:
How can I convert all the records from a Physical File to Exces ?
CPYTOIMPF performance, AS/400 import/export, iSeries import/export, Physical File, V4R4, CPYTOIMPF
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 .
ASKED: May 10 2009  6:24 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24610 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Do you mean Access, Excel, or is this some other format?
In either case, you could use CPYTOIMPF with , delimiters and open it in Excel or import it into access.
You can also link the files to Access/Excel using Client Access ODBC
And remember that Excel cannot accept more than 65000 records.
Phil
Last Answered: May 10 2009  1:32 PM GMT by Philpl1jb   24610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0