Microsoft Excel is a spreadsheet program developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
To create a connection to the Microsoft Excel Data Source, right-click on the Data Sources group, click “Microsoft”, and then select “Excel Workbook”.
To successfully retrieve data from a Microsoft Excel data source, the following properties need to be set.
||Name to identify the data source.|
||Location of Excel file.|
||Retrieve the data either as a standard or wide result.|