I know that you can import worksheets one by one when you import excel files. But I want to now how I can import multiple worksheets from one or more tables at the same time and in a specific way.
So in this case, the fist row is always the name and the first column (species names) is the primary key. The reason I ask this is because I have tables that have over 5 worksheets and it is quite tedious to import one by one.