govert/SQLiteForExcel

sqlite dot-commands

Closed this issue · 1 comments

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

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)