Re: [sqlite] INSERT INTO SQLite from a FixedLength text file

writes: > > > 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

[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

Re: [sqlite] INSERT INTO SQLite from a FixedLength text file

writes: > > > 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

Re: [sqlite] INSERT INTO SQLite from a FixedLength text file

as...@comcast.net wrote: > 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

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

Re: [sqlite] INSERT INTO SQLite from a FixedLength text file

as...@comcast.net 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

Re: [sqlite] INSERT INTO SQLite from a FixedLength text file

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

[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