Simon Slavin wrote : > Also you are still using a 2D array to store your values. This is slow and > requires a lot of memory. Instead, use one array to read in the first row > (with the names of the columns) and then use a second 1D array for each row > of values: read one line in then write the row out, then read the next line > in. You should not need any 2D arrays in your code at all, and you will > never hold the full file content in memory all at the same time.
<FWIW> Would this be worthwhile? I use a 1D array to hold delimited file data, wherein the first element (0) contains the column headings. This allows me to start the records at element (1) so the UBound of the array is the number of records. I find this convenient for setting up the column headings before looping through the records (1 To UBound). -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
