↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About

Tag: database

Using API calls with VBA and Python to Read and Write to a Database

By Vitosh Posted on August 24, 2020 Posted in Python, VBA \ Excel Tagged with API, database, Excel, Flask, GET, Git, POST, Python, VBA
Using API calls with VBA and Python to Read and Write to a Database

Using API calls with VBA and Python to write a database is actually a pretty decent architecture. Here, I would like to say that “It takes the best of the both worlds”, but the truth is that it takes the …

Using API calls with VBA and Python to Read and Write to a Database Read more »

Adding data to SqlLite3 database with Python

By Vitosh Posted on November 2, 2019 Posted in Python Tagged with Bulk insert, CRUD, database, Python, update
Adding data to SqlLite3 database with Python

After reading the database to python from the previous post here, it is time to do the ADD data to the database. Our database is created like this: CREATE TABLE “drummers” ( “Id” INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, “Name” …

Adding data to SqlLite3 database with Python Read more »

Connecting SqlLite3 database to Python and Reading it

By Vitosh Posted on October 31, 2019 Posted in Python Tagged with database, Python, SqlLite3, union
Connecting SqlLite3 database to Python and Reading it

Connecting SqlLite3 database to a Python file is actually 1 line of code: conn = sqlite3.connect(r”C:\Users\database.db”) I have used a database from sqllitetutorial.net, which was rather neat. Then DB Browser for SQLLite a LEFT JOIN was implemented, in order to …

Connecting SqlLite3 database to Python and Reading it Read more »

ASP – Data Entry MVC Application with Database – Video

By Vitosh Posted on August 6, 2019 Posted in ASP.Net, C Sharp Tricks Tagged with .net, asp, C#, data entry, database, MVC
ASP – Data Entry MVC Application with Database – Video

After the first video for MVC here, I have decided to make a next part, in which I save the entries to a database and display them:             Sounds like a tiny update. However, it …

ASP – Data Entry MVC Application with Database – Video Read more »

Copyright © 2026 VitoshAcademy