Microsoft Excel
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. |
Note: To query Excel files, you might be required to download and install the Access Database Engine package. Make sure to install the correct package for your OS.