Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Add Microsoft Excel Data Sources


Overview

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.
 

 

Process

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 sheet fields are selected from will be treated as a separate table within your Staging database.
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments