How to run MSAccess tab from UiPath?

Help Studio
, ,
1

Hi All,

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.

Regards,
Ritesh

2

@Ritesh_Burman

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

Or

You can use database activities to connect to ms access from UiPath

Cheers

3

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?

Regards,
Ritesh

4

@Ritesh_Burman

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

Cheers

5

Hi @Anil_G ,
from where to get the querry details? I think its not a mackro , just linkage of the excel file.
Regards,
Ritesh

6

@Ritesh_Burman

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

Dim objAccess
Set objAccess = CreateObject("Access.Application")

objAccess.OpenCurrentDatabase "C:\YourDatabase.accdb"

objAccess.DoCmd.TransferSpreadsheet acImport, , "tablename", "C:\excel.xlsx", True

objAccess.Quit
Set objAccess = Nothing

Sample code

Cheers