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 )
No comments:
Post a Comment