How do I copy data from main frame computer and keep data in cell
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. |
How do I copy data from main frame computer and keep data in cell
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" wrote in message ... 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. |
All times are GMT +1. The time now is 08:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com