Import file from mainframe

[Dave]

hello

I am looking for a solution for import a file from mainframe to excel

do you have a solution

 

[Nick Hodge]

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)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Dave Peterson]

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.

 

[Earl Kiosterud]

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.

 

[Dave]

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)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

No it's 3270 do you know it ? it's not AS400

 

[Dave]

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.

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 ?

 

[Nick Hodge]

No, I'm afraid I don't but I suspect the same applies

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Dave Peterson]

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.