Sorry if I express myself wrong. What I need is the follows. I have several files with 30+ columns which I need to import into the database. Of course I could write a create instruction and then insert into (..these 30 fields again ..) values. Using the command line I could just load file into a table. Scratch_DB seems to be the very thing I need for this but it seems not to run on ActivePerl. | [reply] |
is it possible to access the command line interface of SQLite
SQLite is an application programming interface (API).
sqlite3 is a command line interface to a SQLite database.
Did you mean "is it possible to access a command line interface to SQLite?"
Did you mean "is it possible to access sqlite3?"
Either way, the answer is surely the same: Yes, sqlite3 is available for Windows.
Using the command line I could just load file into a table.
That should read "Using sqlite3, I could just load file into a table.". Excellent. Exactly what you need.
Update: Rewritten.
| [reply] [d/l] [select] |
I know now how I should ask in the first time :-)
If sqlite3 is in the standard Perl distribution.
The answer is obviously no.
Thanks!
| [reply] |