How to modify data in a database with Excel and VBA/ADO
In the previous article, we’ve seen how to pull data from a database into Excel…
Excel and databases
Excel and databases / Excel as database
How to access Excel Tables / Ranges as SQL Database Tables with VBA
This article illustrates how you can use the ActiveX Data Objects (ADO) library and standard…
Start here: Excel, VBA and ADO for data access
This article illustrates how you can use Microsoft Excel workbooks, VBA and the ActiveX Data…
About this Blog
Welcome to “Excel and databases“, a blog on Excel and databases / Excel as database.…
Real-time Streaming of Excel data to Power BI via VBA (Power BI Streaming Push Datasets)
In this article I’m gonna show you: This tecnique can be useful to test a…