Informatica - How to load data from Excel to Database using Informatica

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 265 of 301

How to load data from Excel to Database using Informatica

Hi,

I am just wondering if there is a direct way to load Excel file into database using Informatica without having to convert Excel to .CSV or XML format. Because we may have to load data from different Excel worksheets.

Thanks in Advance

Srini

Total Answers and Comments: 3

Last Update: March 20, 2008 Asked by: kotasr

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 12, 2007 00:14:01

suvashis

Member Since: August 2007 Contribution: 4

RE: How to load data from Excel to Database using Informatica

hi

in informatica deginer guide there is a detail stape to import EXCEL as a relational source...

Is this answer useful? Yes | No

February 11, 2008 02:59:35

venugopal_p01

Member Since: February 2008 Contribution: 1

RE: How to load data from Excel to Database using Informatica

Please explain the way?

Is this answer useful? Yes | No

March 20, 2008 14:46:38

sravang

Member Since: February 2008 Contribution: 1

RE: How to load data from Excel to Database using Informatica

convert excel file to .csv and then csv to text file...then u can take the source as flatfile..

Is this answer useful? Yes | No

Go To Top