cancel
Showing results for 
Search instead for 
Did you mean: 

Automating against Microsoft Access

ChloeMacIntosh
Level 4
​​Hello,

We have an automation opportunity where excel files are required to be opened in Microsoft Access as they are too large for excel.

Can anyone offer any advice on how we can automate against Access?

Thanks,

------------------------------
Chloe MacIntosh
Automation Developer
Zurich Insurance
Europe/London
------------------------------
1 REPLY 1

Mohammed_OmerAl
Level 4
Hi All, 

We have two solutions to it. 

1)  As you said earlier you always have to refresh manually then only you are able to spy with any mode.i recommend you to put that refresh in your code using global send keys which is F5.

2) Please remove path from application modeller and try to attach with only window title and don't give the process name in the navigate stage of attach. 

Hope this helps you. 



------Original Message------

​​Hello,

We have an automation opportunity where excel files are required to be opened in Microsoft Access as they are too large for excel.

Can anyone offer any advice on how we can automate against Access?

Thanks,

------------------------------
Chloe MacIntosh
Automation Developer
Zurich Insurance
Europe/London
------------------------------