November 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@sqlit
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
Shell
- Original Message
From: RB Smissaert <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, November 15, 2006 2:16:32 PM
Subject: RE: [sqlite] Importing text file via .bat file
> sqlite3 c:\sqlite\ReadCode.db ".read c:\sqlite\ReadCode.sql"
Not
37
To: sqlite-users@sqlite.org
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
sqlite-users@sqlite.org
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 kn
ECTED]
Sent: 15 November 2006 21:37
To: sqlite-users@sqlite.org
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)
ssage
From: RB Smissaert <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, November 14, 2006 3:44:12 PM
Subject: [sqlite] Importing text file via .bat file
Have figure out now what the quickest way is to move data from Interbase to
a SQLite db file:
IB to ADO recordset
Recordse
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 event
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 fi
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, http://www.sqli
-Original Message-
> 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 .im
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 whol
e.org
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
yt [mailto:[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:
>
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 whol
@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 recordset
>Recordset to text
>Import the text file with the .import co
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 with
15:02
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
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, i
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 with a .bat
file.
What I got sofar is:
Have a SQL file with
23 matches
Mail list logo