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 .
Software/Hardware used:
Software/Hardware used:
ASKED:
May 10, 2009 6:24 AM
UPDATED:
May 11, 2009 2:20 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
