Thank you for your reply. I tried in the way that you mentioned. But I am getting an error while I tested the query using the Test Query link. I have attached the screenshot. Am I making a mistake somewhere? Please guide me.
I got an error saying "External table is not in expected format" error before I used this connection string. I resolved it with the help of the below URL. I am linking the URL for easy reference to all:
In my machine Ace.oledb is not installed. Please make sure whether your query is executing in your automation end user system also by making a small automation... Since we faced these issues while UAT phase..