Six Stars

How to get specific cells values from a excel sheet to databases tables?

 Hi, I have a project management excel spreadsheet, where some cell values go to one specific table, some other values go to others, and so on. Is there a way I can get only the specific data to input in the tables?

For instance,  cell B3 will only be load into one table of my DB.

1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: How to get specific cells values from a excel sheet to databases tables?

Hi,

You should have a look at tFileExcel-Components from Talend Exchange.

Hope this helps.

 


TRF
2 REPLIES
Forteen Stars TRF
Forteen Stars

Re: How to get specific cells values from a excel sheet to databases tables?

Hi,

You should have a look at tFileExcel-Components from Talend Exchange.

Hope this helps.

 


TRF
Six Stars JGM
Six Stars

Re: How to get specific cells values from a excel sheet to databases tables?

There are components on the exchange that might help with this. If they dont make it easy, you would need to set up a few filters to isolate each of the "special" cells (row filter to choose the row, then a tMap to chose the column)