I see in Batch types there is a setting called Validation lists which allows to use Odbc to connect to database. In my case I want to use Excel file. I use following connection string:
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=C:\Users\JMarkowski\Desktop\test.xlsx;
When I test connection, it says it's successful, however when I go to document form definition I don't see there any data.
Can you please implement this functionality working with Excel in Decipher?
... View more