Originally posted by: B0JF_Nageswara_Rao_Gummanuru

Hi

Does any one have the sample map in WTX to convert the .xls file to xml
or do we have any external library adapters to conevrt the same

I just noticed through the previous postings that .xls to xml can be handled by the Database interface designer but iam new to WTX Database interface designer(infcat worked on the flatfiles maps in the version Mercator 6.5 can any one help to guide through in creating the ODBC map for conevrting .xls to xml

sample .xls is attached
T
hanks in Advance
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Umer

Hi,

Did you tried the following thread solution already posted by some developer.

You need to set up the spreadsheet as a database. Create the data with column headings and select all of the content (including headings) as a range, and name the range.

Next, create an ODBC connection to thte spreadsheet range.

Then use the Database Interface Designer (DID) to create a type tree for this table. Also, create a Select * from table (range) query in the DID. Use this in your map as the Database source input card

Regards
Umer Farooq
Integration Specialist
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender