Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
How to read an Excel file via ODI 12c? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to read an Excel file via ODI 12c?

Received Response
65
Views
3
Comments

Summary:

Hi Team,

Could anyone please guide me on the below requirements related to excel file parsing using ODI -

  1. Read the excel file placed in a local folder via ODI 12c and place the excel data into an ADW DB table. And please suggest any option other than-> https://blogs.oracle.com/dataintegration/post/how-to-load-data-from-excel-using-odi-1221-and-progress-datadirect-sequelink if at all feasible.
  2. Is it possible to convert an excel file (kept in a local drive) to a .csv file?

Thanks,

Partha

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!