How to create a FlexiCapture Data Set from an Excel table?

Question

How to create a Data Set in FlexiCapture 12 using the data from a table in an Excel file?

Answer

In order to create a Data Set using the data from a table in an Excel file follow the instruction provided below:

  1. Define the Name for a table: select the needed data in a table and choose Define Name from the right-click menu. Enter the new Name for your data. Save and close the Excel file.

  1. Open the ODBC Data Source Administrator (64-bit) application and follow the steps from the screenshot below.

  1. In a Document Definition Editor menu open the Document Definition > Document Definition Properties > Data Sets tab. Open the Data Set and set the Source to Database. Specify the Connection string as follows.
    • Provider: Microsoft OLE DB Provider for ODBC Drivers.
    • Connection:
        • Use data source name: Excel Files.
        • Enter the initial catalog to use: select your workbook from the dropdown.

mceclip0.png

  1. Select the Database table. You should be able to select a table by a Name that was specified in step 1.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Recently viewed