How to create Dataset with Excel table as a source

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:

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.