15, 2006 5:11:38 PM
Subject: RE: [sqlite] Importing text file via .bat file
Not sure if Shell can do something like that.
What would the VB code be?
RBS
-Original Message-
From: Clark Christensen [mailto:[EMAIL PROTECTED]
Sent: 15 November 2006 23:53
To: sqlite-users@sqlite.org
Subj
On 11/15/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
OK, writing the textfile as inserts and running that is a bit slower than
the .import, but it has one advantage and that is that comma's in the field
are no problem as the values can be enclosed in double-quotes.
With the .import I had to take
Not sure if Shell can do something like that.
What would the VB code be?
RBS
-Original Message-
From: Clark Christensen [mailto:[EMAIL PROTECTED]
Sent: 15 November 2006 23:53
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Importing text file via .bat file
Shell
- Original
Subject: Re: [sqlite] Importing text file via .bat file
RBS,
Sorry to jump in late here. Others have given good advice, but I'm
wondering, since this is all running from VB, why not do all the work in VB
and skip the batch (or cmd) file. I'm not a VB guy, but I do know it's
pretty powerful.
Are you
RBS,
Sorry to jump in late here. Others have given good advice, but I'm wondering,
since this is all running from VB, why not do all the work in VB and skip the
batch (or cmd) file. I'm not a VB guy, but I do know it's pretty powerful.
Are you having some trouble with a VB wrapper for
of a file.
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 15 November 2006 20:11
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Importing text file via .bat file
I've noticed that you mention both VB and VBS. Is this something that you
are eventually
November 2006 20:30
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Importing text file via .bat file
On Wed, 15 Nov 2006 19:46:32 -, you wrote:
>Kees,
>
>Just one other thing needed.
>In the .sql file is there a way to notify VB that the text import is
>finished? I run the .bat
it is great software,
especially as I only need as a local, temporary, one user database.
Shame I don't know C.
RBS
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 15 November 2006 20:22
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Importing text file via .bat file
On Wed
On Wed, 15 Nov 2006 19:46:32 -, you wrote:
>Kees,
>
>Just one other thing needed.
>In the .sql file is there a way to notify VB that the text import is
>finished? I run the .bat file now from VBS, so it won't be visible.
>I couldn't see anything suitable in the dot commands to tell VB.
>
>RBS
On Wed, 15 Nov 2006 19:15:38 -, you wrote:
>Hi Kees,
>
>Thanks a lot for that. All working perfect now.
>I think all this should be on the SQLite site as
>it took me a long time to get this fixed.
http://www.sqlite.org/sqlite.html and the .help command taught
me the commands,
essage-
> From: Griggs, Donald [mailto:[EMAIL PROTECTED]
> Sent: 15 November 2006 19:37
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Importing text file via .bat file
>
>
> Echo .mode csv >MyCommands.tmp
> Echo .import ReadCode.t
nesday, November 15, 2006 1:13 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Importing text file via .bat file
Hi Donald,
Thanks, but I don't quite get it yet.
What is in this file MyCommand.tmp?
Is there no way to put the whole thing in on .bat file or even better
run the whole seq
Subject: RE: [sqlite] Importing text file via .bat file
Echo .mode csv >MyCommands.tmp
Echo .import ReadCode.txt ReadCode >>MyCommands.tmp
Sqlite3 ReadCode.db ".read myCommands.tmp"
=
-Original Message-
From: RB Smiss
:[EMAIL PROTECTED]
Sent: 15 November 2006 18:54
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Importing text file via .bat file
On Tue, 14 Nov 2006 23:44:12 -, you wrote:
>Have figure out now what the quickest way is to move data from Interbase to
>a SQLite db file:
>IB to ADO
ember 15, 2006 1:13 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Importing text file via .bat file
Hi Donald,
Thanks, but I don't quite get it yet.
What is in this file MyCommand.tmp?
Is there no way to put the whole thing in on .bat file or even better
run the whole seq
On Tue, 14 Nov 2006 23:44:12 -, you wrote:
>Have figure out now what the quickest way is to move data from Interbase to
>a SQLite db file:
>IB to ADO recordset
>Recordset to text
>Import the text file with the .import command.
>
>Now I am trying to figure out how to automate the last step
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Importing text file via .bat file
Regarding:
"...but how would I combine all this in one .bat file ...?"
Hello, RBS. The following is in windows commandline syntax:
Echo .mode csv >MyCommands.tmp
Regarding:
"...but how would I combine all this in one .bat file ...?"
Hello, RBS. The following is in windows commandline syntax:
Echo .mode csv >MyCommands.tmp
Echo .import ReadCode.txt ReadCode >>MyCommands.tmp
Sqlite3 ReadCode.db ".read myCommands.tmp"
or,
18 matches
Mail list logo