Want to know how to insert Excel data into SQLite in VBA

Currently, SQLite is used to create systems to compare Config and Excel parameter sheets.
I would like to create a VBA that writes Excel data to SQLite.
Currently, we have completed creating the table.

Could you please let me know how I can connect to DB and create a VBA to write to the table, assuming that I have completed searching for the relevant data in Excel?

vba excel sqlite

2022-09-29 22:40

1 Answers

US>To connect to the database from a Microsoft product
We use what is commonly referred to as ODBC Driver.
This allows you to access various databases from a common interface.
The ODBC driver for SQLite can be downloaded from the URL below.

http://www.ch-werner.de/sqliteodbc/

However, the software called SQLiteForExcel is also famous for its combination.
https://github.com/govert/SQLiteForExcel

If you can read English, you should download it and follow the tutorials and samples, and if you search by product name, you will find people who are using it in Japan, so please check it out.

https://qiita.com/hisayuki/items/9b42624790ba74a2fb35
https://qiita.com/hisayuki/items/cd1b6d7bd1a8293647c8

2022-09-29 22:40

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656