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 a DataView 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).