Hi,
We had the ability to take Ascential Datastage Table Definitions and turn them into excel spreadsheets before but we have lost the recipe. Is there some kind of shareware that does this, or a sequence of things you do in Datastage and then on the excel side. The output excel file would have the column name, Declaration, length, etc.. We only have Excel 2000 (not 2003) so I don't think we can read XML directly.
Thanks.
Flash Gordon
Excel output from DS 7.5 Table Definitions
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 99
- Joined: Tue Aug 17, 2004 7:50 am
- Location: Boulder, Colorado
Excel output from DS 7.5 Table Definitions
Flash Gordon
Hyperborean Software Solution
Hyperborean Software Solution
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom