Setting Up A Simple Cloud-based Database and Using VBA to read/write to it

[Chris Macro]

Hello,

I'm working on a personal project where I'd like to have a simple cloud-based database setup (think 10 columns + <5,000 rows). I'd like to be able to use VBA code that can read information from the database and also edit the database (add/delete/modify). Unfortunately, most documentation on the internet assumes the database is already set up and just addresses using VBA code to interact with the SQL database (or whatever).

My questions are:

1. Is there a free/cheap way to set up a cloud-based database that isn't too complex?
2. What is the best coding to interact with said database?

I appreciate your thoughts/advice. I know my way around VBA/Excel, but venturing out into more of an IT realm has been difficult for me to pick up.

 

[rolito]

Hello @Chris Macro ,

I need this too!
Have you found something?

Thanks!

 

[Chris Macro]

I'm currently pursuing using an Excel file stored on OneDrive and using VBA to read/write to it. Not my ideal solution and am still building it out, but hopefully, it will get the job done. My only worry is running into issues where the OneDrive file gets blocked from opening by company IT settings.

 

[rolito]

Hello Chris,

I think this could help (Google API and VBA integration):

https://www.youtube.com/playlist?list=PLo0aMPtFIFDrdnJKwOJ8eRMfUCjkVnswm

And if you need to avoid coding skills, yo have this:

All-in-one data analytics and automation platform | Coupler.io

Gain the most from your data with a complete set of tools and expert services for integration, automation and visualization.

www.coupler.io