I have question about loading excel files into oracle database.
I have access to 12 Excel Files (16 branch) - every excel has 4 four tabs (called: 100,101, 102 and 103)
And now I want load data from excels to four table: 100, 101, 102, 103.
Every excel (and tabs) has the same structure - in this case it's ok.
I have ODI 12.
My question is: how can I import data in ODI from excels and loading it into Oracle Database in Source Scheme?
I know that I can transform this excels to .csv files and it is easy to do, but I must refresh data daily - that's why csv is not a solution.
Unless can I automate transformations .xlsx to .csv? For example I have excel with macro or something else when I use one click and it transform every .xlsx to .csv?
What is a different way?
I find i ODI Technologies Physical/Logical Microsoft Excel - but what with JDBC Driver for it? Can I download for free?
I wll be grateful for any suggestions.