Question

How to create a Dataset inside FlexiCapture12 with an Excel table as a source.

Answer

To do that follow the next steps:

1. Select needed data > Right-click > Define Name > Enter table name > Save and close your excel file. Please check the screenshot below:
2. Then open the ODBC Data Source app and follow the steps from the screenshot below:
3. Then go to Document Definition editor > Properties > Data Sets > Open needed Data Set > Source: Database > Specify Connection string:
   1. Provider: Microsoft OLE DB Provider for ODBC Drivers.
   2. Open the Connection tab.
   3. Select the User data source name: Excel Files.
   4. Enter the initial catalog to use: select your Excel workbook from the dropdown.
4. And the final step is to select the Database table: