MS ACCESS Integration with UiPath Studio

activities
studio

#1

Hi,

Heavy interaction is required with MS Access for a project.

  1. Executing Query(Can be done)
  2. Execute Macro
  3. Import Data(in csv or xlsx file)
  4. Export Data(in csv or xlsx file)

How can I achieve the above?
Is there any custom activity package available to do this?
A sample workflow would be appreciated.
Thanks in Advance :slight_smile:


#2

Hi @Karan_Gupta,

Yes you can achieve by .

Sample File :SqlDatabase.xaml (5.8 KB)

Sample Database : AgeRange.zip (27.4 KB)

image

image

Regards
Balamurugan


#3

Hi,

Thanks for this. It was helpful.
Can you please tell me how to execute a macro which is built-in inside a database file with extension (.accdb) ?

Thanks


#4

Hi @Karan_Gupta,
I didn’t get the activities to execute the macro for Access. But I have created a Custom activity to execute the Macro in Access the I below attached.

Please give me your feedback. And if you need any feature let me know.

Regards
Balamurugan


#5

Wow, that’s very helpful.
Thanks a lot for your amazingly prompt solution.


#6

HI @Karan_Gupta,
Now you can get this package in the Package Manager.

Regards
Balamurugan