Our great sponsors
-
Pandas
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
Keeping data in an Access database which is single-user orientated is problematic as soon as you want multiple users to access the data including some who need to make changes. Converting that to a standard SQL database, be that Microsoft SQL Server, PostgreSQL, MariaDB and accessing it with Python would make for more performant, secure and reliable data access and management. (You could still use VBA to talk to the SQL database.) Look at SQLAlchemy
Python can process more data than Excel and do it faster. Look at pandas.
Related posts
- How To Generate Test Data for Your Database Project With Python
- Snowflake and SQLAlchemy tutorial: From installation to example queries
- Can you please help me understand how this workflow could ne automated using Python?
- Picking a first programming language
- Can anyone share some good examples of Python OOP Repos for DS?