Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet?

Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet?

I got one question like this,,,

“Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet? ”

Here is the Answer. Yes we can import data from multiple sheets from an excel file . Here are the steps

Step 1) Create system DSN for Excel file

Step 2) After creating ODBC Connection for system DSN , Go to Administration tool > File > Import > From Database > Select Data source > select the files which you want to import. ( To Select more than one file press Ctrl & Select )