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. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
