On 2 Jan 2011, at 3:44pm, Alok Singh wrote: > My question is: Can i will able to Insert /Import Tab delimited files into > data base directly using VB.NET with ADONET connectivity, as right now i am > doing through reading files in 2-D array and inserting them line by line. > but its taking huge time and will be drawbacks for my software development.
It will take less memory and be faster if you do it line by line: read one line of the .csv file, then write one row to your SQLite table, then read the next line. You might find it easier to use the sqlite3 command-line application: http://www.sqlite.org/sqlite.html which has this functionality built in. You can do it all using a '.import' command. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
