[sqlite] INSERT INTO SQLite from a FixedLength text file

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

[sqlite] INSERT INTO SQLite from a FixedLength text file

Thank you for the responses. If we import the same text file into a MS Access database using INSERT INTO MDE SELECT * FROM [Text;Database=C:\\folder].[filename.txt], it takes about a minute and half but because SQLite does not support that, I have to use the insert into statement for every

[sqlite] INSERT INTO SQLite from a FixedLength text file

> If we import the same text file into a MS Access database using INSERT INTO > MDE SELECT * FROM > [Text;Database=C:\\folder].[filename.txt], it takes about a minute and half > but because SQLite does not support that, I have to > use the insert into statement for every record inside a

[sqlite] Is Lock Table statement spported?

Is LOCK TABLE statement supported by by SQLite? I am getting syntax error when I execute this "LOCK TABLE tablename IN EXCLUSIVE MODE NOWAIT". Just want to make sure it's not supported rather than my syntax is incorrect. ___ sqlite-users mailing

[sqlite] Is Lock Table statement spported?

I have read those links but there is a reason I want to keep everyone out of the file completely. I did came across "PRAGMA locking_mode=EXCLUSIVE;" and this is what I am doing to achieve what I want. Is there a reason why I should not use this? On 4/20/2011 10:40 AM, asheu at c