'How to import multiple excel sheets into Snowflake database

I'm trying to import data from an excel (.xlsx) which has multiple sheets into multiple tables of snowflake.

Ex, if the excel has 3 sheets named product, sales, profit I want load these data from excel into 3 different tables in Snowflake with same (product, sales, profit) or any name.

Any lead towards solution is highly appreciable!!!

Thanks, Vigneswar

I tried sql commands to import data from Excel to Snowflake, but I was not able to find a way to load data from sheets to table. I have used Put and Copy statement also but I couldn't find option to load from excel sheets.

Solution can be through SQL or Python.

Inputs or leads are highly appreciable!!

Thanks in advance...



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source