Load data from oracle to Excel
HI All,
I want to load data from oracle to Excel. Could someone help me in this first we need to find out whether its possible or not because excel to oracle is possible but vice versa i dont know.
If someone know how to load data from oracle to execl please let me know
Re: Load data from oracle to Excel
it is possible to load data from oracle to excel and vice versa.
i have done it myself.
pls be elaborate on ur qus so that i can help u further:)
Re: Load data from oracle to Excel
Hi,
I am using informatica 7 and reuirement is we need to extract data from oracle and load into Excel.Hw can we achieve that in Informatica 7 instead of informatica 8.Is it possible.
Vishal
[QUOTE=Rdivya;10377]it is possible to load data from oracle to excel and vice versa.
i have done it myself.
pls be elaborate on ur qus so that i can help u further:)[/QUOTE]
Re: Load data from oracle to Excel
Yes it is possible to do it in informatica 7
Re: Load data from oracle to Excel
Hi Rdivya
Can you please tell me how we can load from excel using informatica?
So far i was able to import the tables into my designer and complete the mapping but when i try to run the workflow its failing.
In the ODBC connection I have put the following:
User Name: PmNullUser
Password: PMNullPassword
Connection String: NAME of ODBC connection i.e. ExcelFile (DSN NAME)
Thanks