Simon Slavin wrote : > Ah, okay. First, I don't understand what you mean by 'recordset'.
Hi Simon, Thanks for the info. I understand about the command line feature tool and CSV/TSV file import. Recordsets are common db programming objects, and so I'm a bit awe struck that you wouldn't know what I mean by the term being as you seem to be very knowledgeable in SQLite. I'm assuming (rightly or wrongly) then that you're familiar with db terminology. If I used ADO to grab the data from a delimited file into a recordset, could I then 'dump' that data into a table? My reason for asking is that I don't use commas nor tabs to delimit data. Thus, if I were to convert my apps from storing data in text files to using a SQLite database, I would use ADO to load the data into a recordset. (I'm considering going with SQLite as apposed to using MDBs) Fact is, using text files has its limitations. The file I mentioned in my reply to Olaf was an exceptionally large one for the data my apps store. Most files are well under 5,000 records and so I commonly hold several files in as many arrays at runtime. (Each file would typically be less than 200KB) I think storing the data in a database would be a better idea for larger amounts of data. -- 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
