How to create a data set with Excel table as a source

Question

How to create a data set inside FlexiCapture 12 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 Control Panel > All Control Panel Items > Administrative Tools > ODBC Data Source (64-bit) and follow the steps from the screenshot below:
  3. Then go to the Document Definition editor > Properties > Data Sets.
  4. Open needed data set. 
  5. Select Source: Database.
  6. 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.
  7. Select the database table:

Was this article helpful?

2 out of 2 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.