Connect To A SQLite Database With VBA In Excel
In this tutorial, we are going to learn how to connect to a SQLite database in Excel using VBA and pull records into Excel.
SQLite is a lightweight open source database system. Very similar to Microsoft Access, it stores tables and records as a file, and it doesn’t have the 2GB storage limit like Access has. The drawback with a SQLite database is the database doesn’t come with an interface to manage tables and run queries. Fortunately, there are quite many web applications and free software you can download to manage a SQLite database. If you are an Excel (or Office) application, and needs a database, SQLite is a great choice.
► Resources:
🔨 SQLite Viewer (https://inloop.github.io/sqlite-viewer/)
🔨 Chinook Sample Database (https://github.com/lerocha/chinook-da...)
🔨 Download SQLite ODBC Driver (http://www.ch-werner.de/sqliteodbc/)
📑 VBA Code Used In The Video (https://learndataanalysis.org/how-to-...)
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: https://bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → https://amzn.to/2JkGeMD
📘 Facebook Page → / madeinpython
📘 More tutorial videos on my website → https://LearnDataAnalysis.org
✉️ Business Inquiring: YouTube@LearnDataAnalysis.
Timestamp:
00:00 - Intro To SQLite Database
00:45 - Download SQLite ODBC Driver
01:50 - Download A Sample SQLite Database (Optional)
02:25 - VBA Code To Connect To A SQLite Database
#SQLite #VBA #Database #Excel
Watch video Connect To A SQLite Database With VBA In Excel online without registration, duration hours minute second in high quality. This video was added by user Jie Jenn 26 January 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,030 once and liked it 138 people.