search

govert / SQLiteForExcel

A lightweight wrapper to give access to the SQLite3 library from VBA.
MIT License
256 stars 81 forks source link

sqlite dot-commands #8

Closed marnhaccharles closed 5 years ago

marnhaccharles commented 5 years ago

Hi,

Many thanks for this work. However, is it possible to use dot-commands in vba script code? i.e: .import file.csv

Many thanks

govert commented 5 years ago

No, I don't think so - those are part of the SQLite3.exe executable shell. I guess you could put the SQLite.exe in a known location and the run the program from VBA (search for "run exe with parameters using vba" or something similar)