Importing Data from Multiple Sheets in an Excel File into Multiple Database Tables

[Hari S1]

Hi,

In an Excel file, we have three sheets: Sheet1 contains user-related data, Sheet2 contains group-related data, and Sheet3 contains Windows server-related data. If we want to import the data from these three sheets into three different tables at the same time, how can we do that?

Thank you

[Sanjay191]

Hello @Hari S1 

You could use the sheet number to get the record of particular  sheet like sheet 1, sheet 2 and sheet 3 and need to Create Data Source for the three  different sheet and run the transform map accordingly . And also You can use the Robust Transfer for this to load data for the more then one table .

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You