Simon Slavin formulated the question : > On 6 Jan 2011, at 8:18pm, GS wrote: > >> I just checked a 21,000 line x 30 column delimited file and it is >> 817KB. I draw the line (for performance and/or convenience working with >> the data) at about 50K lines before I'd use ADO to load the entire file >> into a recordset, OR criteria-specific recordsets depending on how I >> want to work with it. >> >> What I was hoping to learn here is whether we can dump an entire >> recordset into a SQLite table. Is that doable. > > Are you worried about how many columns, rows or bytes you can store in SQLite > ? The size you mention is nowhere near the capacity limits. You won't have > any trouble with that amount of data. > > If you're worried about something else, please make the question clearer. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I'm not worried about anything. I merely wish to know if we can create a new table in SQLite and 'dump' a recordset into it. So if data was 'dumped' from a database into a delimited file, can we load that data into a recordset and 'dump' it back into a SQLite table? Thanks! -- 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
