I'm using QSpatialite only. I don't have spatialite-gui neither the shell.
I want to import multiple TXT/CSV at one time. How is it possible to do that ? I found nothing on the internet.
You'll definitely want to install the spatialite shell program and run the imports in a loop. You can write a simple sql/sqlite command file (let's call it imports.sql) with lines like:
=== Edit ===
Here are some more details. I tried on a small set of simple csv files, and it seems to work: First a loop (run on linux) to collect all the files into one "import.sql" command file.
Now I ran:
Tables were created and the data rows imported. You have to make sure your CSV files are identical in structure, and "clean" i.e. no extraneous commas, text should be quoted, etc. And of course you will need design the above "CREATE TABLE statement to match the columns in the CSV files.