I’m very new to SQL programming. I have used dzt’s program under ”Convert Any Database to SQLite(source & exe) to convert my CSV file to SQLite(.sl3) file.
After converting to SQLite file (test.sl3), its look very difference from your northwind.sl3 file.
Attached is my CUSTS2.CSV file. Can you help or any suggestions on ways to convert files?
You can use Connection.CreateSQLTable to convert your CSV file.
Using a Table control load the file with Table.LoadCSV.
Now export the table data to a SQL table using Connection.CreateSQLTable.
There is a small example here: http://www.b4x.com/help/sql/index.html