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 fileODBC -system DSN
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 )
123
1234

No comments:

Post a Comment

Popular Posts