<asheu@...> writes: > > 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. I have tried many syntax and getting syntax error. I am not sure if I have the > syntax incorrect or it's just not supported in SQLite. I know you can use import command to import a csv to > sqlite but I am looking for sql statement that does the work. > > 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 than we would like and is looking for something to speed up the > process.
No, it is not supported in sqlite - but it's simple to preprocess the whole file with the language of your choice (i.e. gawk is optimised for such problems) greetings oliver _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
