I have a database that pulls 2 excels in as tables. I created a query between those 2 tables. I want UiPath to run the query, export the results and then email it out to different parties. The emailing of an exported result is simple but I can’t find any good documentation on how to run an MS access…

Hi! See this post: [image] MS Access database connection Studio @bcm Step: 1 : Click on Configure Connection [image] Step: 2: Click on Connection Wizard [image] Step: 3: Click on Microsoft access Database file [image] Step: 4: Provide your Database file name, Crede…

Hello @atarantino Refer to this video, you may get some idea. [UiPath and MS Access Automation Complete Tutorial in 45 minutes || UiPath RPA]

Thanks but this isn’t were my issue lies. I can connect to the database no problem. I don’t know how to have UiPath execute the existing query and export results to .xlsx.

Ah ok. Use this activity after having connected to it. https://docs.uipath.com/activities/other/latest/user-guide/execute-query The output will be a datatable. Then write the datatable to an excel with this. https://docs.uipath.com/activities/other/latest/user-guide/write-range-x

Hello, sorry, i’d like how did u do your executing query process

Thanks I’ll work on this and mark solution if successful.

Follow these steps- To run a Microsoft Access query using UiPath, you can follow these steps: Install the “System.Data.OleDb” package in UiPath Studio if it is not already installed. This package provides the necessary activities to interact with Microsoft Access databases. Use the “Connect” acti…

Run MS Access Query

Help Studio

sven.wullum1 April 18, 2023, 5:47am 2

Hi!

See this post:

Topic		Replies	Views
Steps to connect to MS Access Database from UiPath Studio Knowledge Base activities	0	331	January 3, 2025
access Help	2	1767	October 31, 2018
ExcelToAccess Academy Feedback uiautomation	3	2109	August 30, 2018
MS ACCESSでのクエリー実行フォーラム activities	4	3791	October 24, 2019
MS ACCESS Integration with UiPath Studio Help activities , studio	20	11204	November 22, 2023

Run MS Access Query

Related topics