↓ 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

Home › Posts tagged database
Using API calls with VBA and Python to Read and Write to a Database
Python, VBA \ Excel

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

Vitosh Aug 24, 2020 Tagged with API, database, Excel, Flask, GET, Git, POST, Python, VBA

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
Python

Adding data to SqlLite3 database with Python

Vitosh Nov 2, 2019 Tagged with Bulk insert, CRUD, database, Python, update

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
Python

Connecting SqlLite3 database to Python and Reading it

Vitosh Oct 31, 2019 Tagged with database, Python, SqlLite3, union

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
ASP.Net, C Sharp Tricks

ASP – Data Entry MVC Application with Database – Video

Vitosh Aug 6, 2019 Tagged with .net, asp, C#, data entry, database, MVC

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