 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Import file from mainframe
hello I am looking for a solution for import a file from mainframe to excel do you have a solution Dave It depends what protocols/drivers your 'mainframe' supports/has. Most modern ones AS400, etc support ODBC and this can be accessed via Data>Get External Data>New database query... If your 'mainframe; is in the list of drivers installed as you travel through the wizard, then you're set to go. If no you will need to ask an admin if drivers are available and get them installed locally on your machine (ODBC would be the easiest)  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk > hello > > I am looking for a solution for import a file from mainframe to excel > > do you have a solution > Dave > [quoted text clipped - 10 lines] >> >> do you have a solution No it's 3270 do you know it ? it's not AS400 No, I'm afraid I don't but I suspect the same applies SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk >> Dave >> [quoted text clipped - 11 lines] >>> do you have a solution > No it's 3270 do you know it ? it's not AS400 If if you just FTP'd your file from the mainframe to a text file on the pc, you can open excel and use File|Open and parse the fields into separate columns. > hello > > I am looking for a solution for import a file from mainframe to excel > > do you have a solution SignatureDave Peterson Dave, Many mainframes have support for attached PC's. There are terminal emulation programs (5250 or 3270 for IBM mainframes) which have PC support add-ons, as well as stand-alone PC support programs, which include file transfer utilities, which do the code translations (EBCDIC-ASCII) and often have query capabilities built in. A lot depends on the mainframe. SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > hello > > I am looking for a solution for import a file from mainframe to excel > > do you have a solution > Dave, > [quoted text clipped - 9 lines] >> >> do you have a solution Yes I can import file with 3270 but I have probleme with numeric packed (example PD6.2) for translate in my PC :( do you have a solution ? Do the packed decimal to ASCII conversion on the mainframe. If you don't have access to some sort of programming language (some sort of a report writer), then talk to your IT department to have them give you an ASCII dump of the data. > > Dave, > > [quoted text clipped - 17 lines] > (example PD6.2) for translate in my PC :( > do you have a solution ? SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.