Excel file

[rmeenakumari822]

Hi,

iam new to Datastage...

How to import Excel file to Datastage?

what r the steps to follow....

Thanks

[ray.wurlod]

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.

[monaz]

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

[PhilHibbs]

you can do it as saving the excel file as .csv file and use a sequential file by reading from .csv 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.