How do I copy data from main frame computer and keep data in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert oval frame arund cells? 7
Excel 2007 - copying filtered data to another workbook 1
copying data down columns 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Lookups - how to obtain data from a master spreadsheet into another 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
how to export excel sheet (dynamic data) in spreadsheet ? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top