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

[Anonymous]

 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.

[TRF · Accepted solution]

Hi,

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

Hope this helps.

[Anonymous]

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)