Power Automate Tutorial - Calling Excel VBA to connect to a 32 bit ODBC Datasource
This is part of a larger solution for our client. They are running Sage 50 Accounting, which is 32 bit and provides 32bit ODBC drivers. Power Automate is 64 bit and cannot connect to 32 bit data sources.
More details and downloadable code and FLOW can be found on The X-Code Expert Substack, here:
https://xcode.substack.com/p/power-au...
However, Power Automate can connect to 32 bit Excel files and run macros (VBA code).
We have an Access DB (32 bit) linked to the client's Sage 50 data. We wrote Excel VBA code that connect to the Access DB (linked to Sage) to run SQL and query the data we need to get our selected Sage 50 products.
This video covers the Excel VBA and running it from Power Automate.
========================
Matthew Moran is the founder of Achieve Data Solutions - a business workflow automation and database consultancy. He is a 25+ year technology consultant.
He's authored two books on careers in I.T and numerous articles, blogs, and essays on technology, creativity, business, and automation.
https://achievedatasolutions.com
https://xcode.substack.com