Sign in

Data Source - Microsoft Excel

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”.

DataSources-Excel.png

To successfully retrieve data from a Microsoft Excel data source, the following properties need to be set.

DataSources-ExcelProperties.png

  • Name (String)
 Name to identify the data source.
  • Excel Workbook File (File location)
 Location of Excel file.
  • Query Type (Dropdown)
 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.