On 3 Jan 2011, at 9:08pm, GS wrote: > Looping through the array gives me access to each record if I start the > loop at vaDataArray(1), thus the loop parameters of '1 To > UBound(vaDataArray)'.
I have twice suggest you do not do this. Holding the entire data in memory at the same time will take a lot of memory and cause your program to run slowly. If all you are doing is turning a CSV file into SQL you never need to hold the entire file in memory. Read one line of your data from the file into an array. Generate one INSERT command to write it to the database. Then reuse the same array to read in the next line of your data: you don't need the previous line any more. This should make your application run many times faster than it did before. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
