Creating a OleDB DataSource

Use the Sources Manager Tree or the Project Configuration dialogue to Create or Edit a new OleDB DataSource.

Configuring the OleDB DataSource

To setup a OleDB DataSource:

• Enter the Connection String to connect to your source. See some examples here: https://www.connectionstrings.com/net-framework-data-provider-for-ole-db/

Configuring the OleDB DataView(s)

You can create DataViews from multiple files, sheet, or source depending on the OleDB driver you are using. To create a new DataView, from the DataSource Configuration dialogue click the New DataView button. Refer to the section Configuring aDataView  for more ways to create and edit DataViews.

To configure an OleDB DataView:

• Enter a view Name
• Type the query to run on the data (ensure the syntax matches that supported by the OleDB driver that you are using).