Uipath excel import to ms access automation

I want to import the excel to ms 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 at there, other double clicks are fine besides this…Can someone help me please…or maybe I heard that these steps can use codes to achieve it !?

There are a few things you can try to overcome this:

  1. Try to use combination of ‘Simulate Click’ enabled or disabled.
  2. If it still doesn’t work, it’s possible that your selector is matching more than one buttons (or no buttons at all). Hence, it fails. Try to make it more specific or less specific accordingly.
  3. I notice that the selector’s suggested matches in the log have this text (&O). Try to replace that with asterisk sign ( * ) to match that special character. The button for OK has shortcut (O) but it is translated as & in the HTML format.
    Replacing that string should certainly fix that.
1 Like

I hope this issue is resolved. :slight_smile:
Glad to be of assistance.

Haha, I saw it, thanks :blush:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.