[email protected] wrote: > I know you can insert into MS Access from a FixedLength text file using > schema.ini with this: > INSERT INTO MDE SELECT * FROM [Text;Database=C:\\folder].[filename.txt] > > Is this supported in SQLite.
No. > I know you can use import command to import a csv to sqlite but I am looking > for sql statement > that does the work. There is no such statement. .import command parses the file and issues a regular INSERT statement for each line. > I know you can also read the records in and then using insert statement on > each records to insert into sqlite. I have done 't > that but it's a little slower Slower than what? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
