hi guys I hope to get help on this, I have an excel sheet which is like a letter with fields that I need to copy from mainframe. Does anyone know how to do it. Please help if you can, this is important for me. I need a macro in excel to copy fields from the mainframe system to the excel defined fields. I just need to get started. Thanks a lot.
Copy from mainframe" Hope to get help"
- Thread starter mr moe
- Start date
- Local time
- Today, 08:54
- Joined
- Feb 19, 2002
- Messages
- 48,010
The mainframe is pretty nebulous. What kind of file holds the data? If it is a relational database, you can link to it from Access. If it is something else, you'll need to have a mainframe programmer create a text file extract for you and set up an FTP so that the text file gets copied to a server where you can access it.
We can't help without more details.
We can't help without more details.
Sorry for trying to help, actually tihs is something my friend has asked me to help him with, i don't think that is a database it's an old mainframe system, what they do now is open the mainframe and the run a vba macro to copy the screen data into the excle sheet which is like a letter formate, they copy like the customer's name and address ect.. then they print it and mail it to the customer. I was just wondering if there is a similar example in here, I will get more details after I ask him. Thanks.
- Local time
- Today, 08:54
- Joined
- Feb 19, 2002
- Messages
- 48,010
No one can help you without knowing EXACTLY what mainframe application/database that you need to get data from.
neileg
AWF VIP
- Local time
- Today, 12:54
- Joined
- Dec 4, 2002
- Messages
- 5,975
From what you say, it sounds like you are running some terminal emulation software on the PC and that the data is being retrieved from that, not from the mainframe itself. While that potentially makes the job easier than it might otherwise be, it still leaves a huge amount of information missing before anyone here can help.
