Hi,
iam new to Datastage...
How to import Excel file to Datastage?
what r the steps to follow....
Thanks
Excel file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Sat Oct 25, 2008 9:09 pm
- Location: chennai
Excel file
priya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Import via ODBC table defnition. Make sure that you require system tables to be included, because the ODBC driver for Excel reports worksheets as system tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Excel file
rmeenakumari822 wrote:Hi,
iam new to Datastage...
How to import Excel file to Datastage?
what r the steps to follow....
Thanks
you can do it as saving the excel file as .csv file and use a sequential file by reading from .csv file
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: Excel file
We have tons of Excel spreadsheets that are used as either straight input data or as translation tables in our data migration process. We use a handful of additional "driver" Excel spreadsheets to organize them, with VBA code that opens each of the spreadsheets in turn and writes the contents of the listed tabs out to CSV files. One of these driver sheets writes everything out to a single CSV file that is read into a monster hashed file and used as a combined cross-reference for all our translations (units of measure, cost centres, profit centres, GL codes, etc.), whereas the others write out a separate CSV file for each input tab. Another bit of VBA FTPs the files up to the DataStage server (AIX) so the .csv files are all sitting there ready to be read by DataStage.monaz wrote:you can do it as saving the excel file as .csv file and use a sequential file by reading from .csv file
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant