Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

HarikrishH
Tera Contributor

‎12-05-2024 10:14 PM

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

0 Helpfuls
  • 730 Views
1 REPLY 1

Sanjay191
Kilo Patron

‎12-06-2024 12:15 AM

Hello @HarikrishH 

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