Can we convert exel file to XML file using informatica ?

Showing Answers 1 - 9 of 9 Answers

wanilkumar

  • Oct 6th, 2011
 

There is no default driver available for reading from Excel files. You need to export the Excel file into a comma delimited or tab delimited file and then you should define a XML type Target and load it.

  Was this answer useful?  Yes

kumar

  • Oct 21st, 2011
 

first we need to save the excel file in csv file and then we have xml transformation in informatica by using that we can convert csv file to xml file

  Was this answer useful?  Yes

vizaik

  • Oct 25th, 2011
 

Excel source is possible through File DSN - Target XML also can be done - read the documentation or help for more information

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions