Importing more than one sheet from Excel to MySQL

[hackedman]

Hi,

to import database from Excel file to MySQL we have to write down this code :

LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;

and before that we format the SQL table to fit with the ones of Excel.

But, my question is : If we have in our Excel database more than one sheet, how can we select the proper sheet that we need ? For example, importing all columns and rows from sheet 2 instead of 1 ?

Thank you
HackedMan