Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- SS&C Blue Prism Community
- Get Creative
- Product Ideas
- Validation list with ODBC and Excel
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
jakub.markowski
Level 3
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
30-11-23
02:21 PM
Status:
New
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Idea Statuses
- New 834
- Duplicate 76
- Needs More Info 50
- Reviewed 215
- Under Consideration 152
- Not Planned 83
- Planned 54
- Planned-Later 21
- Planned-Next 6
- Planned-Now 11
- Delivered 136
