CODEWITHSUNDEEP
excelms-accessrpauipath
Violétte
Violétte

Reputation: 13

Uipath excel import to Microsoft Access automation fails

I want to import the excel to Microsoft Access, and this process is automation, so I use double click to achieve it. Everything is fine until it stopped at one step which needs to click the OK button after import the xlsx file.

I don’t know why it stopped there, other double clicks are fine besides this.

UiPath Studio

And a video about it:

https://www.youtube.com/watch?v=KI4hg_9zRVI

Upvotes: 0

Views: 552

Answers (1)

Conor
Conor

Reputation: 740

So it sounds like you want to achieve the following.

  • You have a spreadsheet of data
  • This data needs importing into a database (MS Access)

One of the 'problems' with RPA/Automation is that we tend to automate actions rather than outcomes.

As a solution, rather than automating how a human would interact with MS Access and complete this task, think more about what you're trying to achieve.

At a very high level, you could do the following in your workflow, I've included links to UiPath documentation for each of the steps/activities.

  1. Use read spreadsheet activities in UiPath to extract the data from your spreadsheet excel-read-range
  2. Parse/Validate/Filter the data you have just read filter-data-table
  3. Establish a database connection to the MS Access database database-connect UiPath forum example
  4. Perform a SQL query to insert the data from the spreadsheet into the database execute-query

Upvotes: 0

Related Questions