I have an excel with vendor details which is being updated on a daily basis.
I wan FlexiCapture to access this excel for the vendor dataset.
I tried to setup the vendor dataset with the Microsoft ACE OLEDB driver, when I check the connection to the excel it is successful. But when I try to select a sheet from the dropdown I don't see any and tables(Excel Sheets).
Could you please let me know how I can use this data in my excel to configure the data set in Flexicapture.
Thanks & Regards,