Question

How will you use an Excel sheet as a data source​

Answer 1

Using a Microsoft Excel File Stored in a File Directory Data Source

•Click the New Data Set toolbar button and select Microsoft Excel File. ...

•Enter a name for this data set.

•Click Shared to enable the Data Source list.

•Select the data source where the Microsoft Excel File resides.

Answer 2

Using a Microsoft Excel File Stored in a File Directory Data Source

•Click the New Data Set toolbar button and select Microsoft Excel File. ...

•Enter a name for this data set.

•Click Shared to enable the Data Source list.

•Select the data source where the Microsoft Excel File resides.