View previous topic :: View next topic
|
Author |
Message |
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
I have a requirement to transfer excel (.xls) data to Mainframe. I understand that we can use SFT to transfer the data to Mainframe. But want to understand how the column data in excel will be imported to mainframe i.e.e any specific seperator we can put like comma or semi-clon in the mainframe sequential file to separately identify the Excel column data. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
In Excel, save the worksheet as a comma-delimited (CSV) file. You can then transfer that file to the mainframe as text. You may need to repeat the process if there is more than one worksheet in the spreadsheet.
If you want to transfer the Excel .XLS or .XLSX file to the mainframe and be able to use it at all, you either need to have a package on site (or have your site buy one), or write an application to convert the data yourself (the Microsoft file format document, the last time I looked, was over 1000 pages and growing with every release). |
|
Back to top |
|
|
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
Thanks.
I got that in Excel, save the worksheet as a comma-delimited (CSV) file. And then transfer that file to the mainframe as text.
But I need to udnerstand how the Column data from excel will be separated in mainframe sequential file. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Well that depends on what you do in Excel. If you tell it to use commas as delimiters you will get a mainframe sequential data set with commas in it.
Rather than asking on a forum, if you had generated a file and sent it to the mainframe, you could have your answer a while ago. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Save the Excel file as CSV, then open it in Notepad, that's how it would look. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
the COBOL Statement UNSTRING will be helpful.
the description, use and examples are found here |
|
Back to top |
|
|
|