Sign Up for Training |
Jet Global Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Adding a Microsoft Excel Data Source to the Jet Data Manager


Data sources contain the data that you want to retrieve and use for analysis. This article details the required steps to add an Excel file as a data source.

To use Excel files as a data source, you must ensure that the worksheet data is in list format. This means that the data must be set up in a database format consisting of one or more named columns.
Your license determines the number and type of data sources that you can connect to. A standard license permits a connection to one data source. Additional connectors can be purchased to permit the use of additional data sources.



Add Microsoft Excel Data Sources

1. On the Data tab, expand the preferred business unit, and then right-click Data Sources .

2. Select Data Sources , and then select Add Excel data source to display the Find Files or Folders dialog.

3. Navigate to and select the Excel file you want as data source, and then click OK .

4. Once added, right-click on your new data source entry and select 'Read objects from Data Source'
5. With your focus on the new Excel data source, you should now see the sheets within your Excel file listed in the right-hand pane. Each sheets fields that are selected will be treated as a separate table within your Staging database.
Once the table has been added in the Staging database, Deploy and Execute the table. 
Was this article helpful?
0 out of 0 found this helpful