I have to click on one prebuild tab(Pre- Linked of excel Files with the path with left Bar tab named(xyz)) inside MSAccess but I want to avoid Ui Automation , i want to run that tab directly from command prompt or by some other method. Is there any way or option anyone knows who have already deal with MsAccess before using UiPath.
May I know what is the requirement and what you want to do on masaccess …ideally we can do the taska through backend using vb code
You can use database activities to connect to ms access from UiPath
Hi @Anil_G ,
I need to open the ms access database and then manually clicking on xyz tab which is pre linked with the excel file and after clicking new updated excel will be loaded to ms access data base, this manual process need to be automated by the bot and i need to avoid UiAutomation. Do u have any idea or any querry that we can run the ms acess tab from command prompt?
If its a prelinked tab then there would be a macro or a backend query that would be running…you can do that from
UiPath by accessing the msaccess as a db…so first try to get to know the process and query details…that way you need not open and click
Hi @Anil_G ,
from where to get the querry details? I think its not a mackro , just linkage of the excel file.
In access db you can also record a macro or you can write a vbscipt to do the same task…or record macro and call it from vbscript and it can be inturn called from UiPath
Set objAccess = CreateObject("Access.Application")
objAccess.DoCmd.TransferSpreadsheet acImport, , "tablename", "C:\excel.xlsx", True
Set objAccess = Nothing