On 6 Jan 2011, at 11:59pm, GS wrote: > 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
I'm guessing you mean a file in comma-delimited or tab-delimited format. > , can we load that data > into a recordset and 'dump' it back into a SQLite table? Ah, okay. First, I don't understand what you mean by 'recordset'. This might be a feature used by the programming language you're using. The SQLite command-line tool includes features which convert between a SQLite table and a CSV file. You can call it and tell it entirely what to do using one command, so if you have access to your operating system's 'exec' command you can do the conversion all in one go. http://www.sqlite.org/sqlite.html At no point is all the data held in memory at one time: it reads a record, then writes a record, etc.. If the tool did this it would make it useless for very long files. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
