topic Re: Import data from Excel to Oracle table in Talend Studio

Import data from Excel to Oracle table

Anonymous — Wed, 31 Aug 2016 10:08:06 GMT

Hi all,

I thought it would be much simpler to do that but could you please provide advice on the following:

I have an excel file which contains about 10 rows only. I want to use this excel file and link it with another
table using tMap and then load data from both tables into another Oracle table.
When I run the job I notice from the excel file it reads 0 rows which makes no sense since there are 10 rows in the excel file.
Also in the execution window I see with red colour "null" - I believe for every row I have in my Excel file.

Any advice or work around of what might have caused this problem?

Thank you in advance.

Regards,
Leantros

Re: Import data from Excel to Oracle table

Anonymous — Wed, 31 Aug 2016 10:44:18 GMT

Hi Leantros,

how do you have created the excel structure in your job ? and the link in tMap ?
It's better to import the xls structure with Talend and it shows you a data preview.

Re: Import data from Excel to Oracle table

Anonymous — Wed, 31 Aug 2016 11:05:06 GMT

Hi Carlos,

I created a new File Excel from Metadata and then linked it with an existing excel file from a location from my computer.
Then I use this excel file as a tFileInputExcel and by a tMap I want to link it with a table.
When the procedure begins to retrieve data from the Excel file I see 0 rows coming from the excel which is strange
since it has about 10 rows which I could see them during the wizard...

Re: Import data from Excel to Oracle table

Anonymous — Wed, 31 Aug 2016 14:09:59 GMT

The problem was the excel file... I just copied the data into another and it works ok. maybe the extension if its workbook or .xlx plays role...