Steps to connect to MS Access Database from UiPath Studio

News Knowledge Base
1

Information required on MS Access database connection or Connecting UiPath to ODBC Data Source via Microsoft Office Database Engine.

Overview: To enable connectivity between UiPath and an ODBC data source using the Microsoft Office Database Engine, follow these steps:


  1. Configuration of ODBC Connection:
    • Ensure successful ODBC connection test before proceeding to UiPath configuration.
  1. Open Connection Wizard in UiPath:
    • Click on the "Configure Connection" option to launch the Connection Wizard.
  2. Provider Selection:
    • Choose the Provider Name as either "Microsoft Office Database Engine" or "Microsoft.Jet.OLEDB.4.0" based on available options in the dropdown.
  3. Connection String Setup:
    • For an Access database, an example connection string may resemble this format:
    • Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourPath\YourDatabase.mdb;
    • Replace "C:\YourPath\YourDatabase.mdb" with the actual path to your .mdb file.
  4. Test Connection:
    • Verify the connection's success by clicking the "Test Connection" button.

Now, the connection is successfully established and it is possible to execute the required queries.