Question
How to create a Dataset inside FlexiCapture12 with an Excel table as a source.
Answer
To do that follow the next steps:
- Select needed data > Right-click > Define Name > Enter table name > Save and close your excel file. Please check the screenshot below:
- Then open the ODBC Data Source app and follow the steps from the screenshot below:
- Then go to Document Definition editor > Properties > Data Sets > Open needed Data Set > Source: Database > Specify Connection string:
- Provider: Microsoft OLE DB Provider for ODBC Drivers.
- Open the Connection tab.
- Select the User data source name: Excel Files.
- Enter the initial catalog to use: select your Excel workbook from the dropdown.
- And the final step is to select the Database table:
Comments
0 comments
Please sign in to leave a comment.