Problem Converting CSV to SQLite

tcgoh

Active Member
Licensed User
Longtime User
Hi Erel,

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?

Thanks
TC
 

tcgoh

Active Member
Licensed User
Longtime User
Tks Erel,
I used dzt's example and my sl3 file come up very difference. please see attached. Not sure I got is right?
Thanks.
 

dzt

Active Member
Licensed User
Hi,

I've tested your CSV with my example and it produces a valid SQlite database.

My example uses mainly Connection.CreateSQLTable, plus the VB6 program to produce the CSVs from databases
 

tcgoh

Active Member
Licensed User
Longtime User
Hi dtz,

Thank you for looking into my problem. Could you kindly give me an example (or codes) on how to use Connection.CreateSQLTable and export to .sl3 file.

Many thanks
TC
 
Top