load data from multiple sheets in Excel

[Anonymous]

Hi everyone,

i have a excel data like the picture belows. i want to load this Data to new Table in our data base. the result should look  like this:

number   saleperson  salevolume   salezone

1               A                   23                 34ASD

2              B                   43                  34ASD

.....

Can you please help me how to do that?

Thanks

[Anonymous]

Hello,

You can enter the number of rows to be skipped in the beginning of file by using tFileInputExcel component to load this Data to your table.

The 'salezone' field is filled in static value?

Best regards

Sabrina