Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Import data from Excel to Oracle table

Highlighted
One Star

Import data from Excel to Oracle table

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

Highlighted
One Star

Re: Import data from Excel to Oracle table

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.
Highlighted
One Star

Re: Import data from Excel to Oracle table

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...
Highlighted
One Star

Re: Import data from Excel to Oracle table

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...

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog