Originally posted by: manojmmx

Hi,
Can we read the data from excel file (.xsl) as input to a map ? and how ?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Yes you can though in general not something I would suggest for very active systems.

1. Create table in Excel compatible with ODBC. You must name the range of cells you will mine.
2. Create trees from the Excel data using the Database Interface Designer. Choose the range of cells (by name) that you will use.
3. Use trees in map with MDQ file using ODBC as the adapter.

There is also the DDEQUERY function but I do not think that is what you mean.

Yvonne Ricard
Resistance is NOT futile.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: DianeC

You can also export the data from Excel to a comma delimited file and read that (using a type tree you create for it) into your map.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange