by mor | Feb 18, 2021 | Blog
Send any SQL statement for execution by a remote Database Server from your VBA program * DDL statements allow you to create and alter the schema from your program * Today we write a generic VBA function for adding a column to a table in the Database This Blog post... 
by mor | Feb 11, 2021 | Blog
Turn Excel into a powerful information systems development platform * Enjoy the power of a relational Database in your Excel VBA applications * Business applications like you never thought possible with Excel * Today we write SQL queries from Excel VBA to MySQL DB Be... 
by mor | Feb 4, 2021 | Blog
Turn Excel into a powerful information systems development platform * Enjoy the power of a relational Database in your Excel VBA applications * Business applications like you never thought possible with Excel * Today we setup and prepare Excel VBA and MySQL Server Do... 
by mor | Jun 18, 2020 | Blog
Excel offers large Worksheets. Data can be arranged and stored flexibly, searched and acted upon. Do we have a Database here? * Let’s sort out Excel as a Database. What is a Database? Simply speaking, a database is any structure in which data is to be arranged along... 
by mor | Jun 4, 2020 | Blog
If you ever needed to query Excel tables (and who hasn’t) from your VBA programs that contained thousands of rows, or join multiple tables in the process – this is the Blog post you’ve been waiting for * Write complex SQL queries over Excel tables as if they were...
Recent Comments