I am trying to copy data from a main frame computer and put on excel
spreadsheet. How do I do this and keep basic format? There are 3 line item
per screen and about 15 screens.
I am trying to copy data from a main frame computer and put on excel
spreadsheet. How do I do this and keep basic format? There are 3 line item
per screen and about 15 screens.
Same the data from mainfram as a text (ASCII) file and transfer to PC; Open
with Excel and use Data |Text to Columns to separate items.
Better yet, if main frame allows,: save data in a comma delimited file -
commas between each item. Excel will open this and recognize the fields if
you call it something like Mydata.CSV
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Doug" <[email protected]> wrote in message
news:[email protected]...
>I am trying to copy data from a main frame computer and put on excel
> spreadsheet. How do I do this and keep basic format? There are 3 line
> item
> per screen and about 15 screens.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks