RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread Anderson, James H \(IT\)
Thanks! -Original Message- From: jphillip [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 4:24 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Is there a method for doing bulk insertion? issue .help look for .separator example for a csv file with colon(:) separators

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread jphillip
e's no way to use a delimiter other than a > comma to import a CSV file? > > -Original Message- > From: jphillip [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 19, 2006 3:47 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Is there a method for doing

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread Anderson, James H \(IT\)
Thanks! -Original Message- From: Jeff Godfrey [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 4:01 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for doing bulk insertion? Take a look at the ".separator" command. It seems to be what

Re: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread Jeff Godfrey
Take a look at the ".separator" command. It seems to be what you need... Jeff - Original Message - From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: Sent: Tuesday, December 19, 2006 2:52 PM Subject: RE: [sqlite] Is there a method for doing bulk in

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread Anderson, James H \(IT\)
] [mailto:[EMAIL PROTECTED] > Sent: Monday, December 18, 2006 9:12 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Is there a method for doing bulk insertion? > > "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > > or do I have to creation a g

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread jphillip
ilto:[EMAIL PROTECTED] > Sent: Monday, December 18, 2006 9:12 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Is there a method for doing bulk insertion? > > "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > > or do I have to creation a gazillio

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread Anderson, James H \(IT\)
How do I find doc on .import? Is there a way to specify the delimiter for the CSV file? Thanks, jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 18, 2006 9:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread Anderson, James H \(IT\)
Thanks. -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Monday, December 18, 2006 8:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for doing bulk insertion? On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I w

Re: [sqlite] Is there a method for doing bulk insertion?

2006-12-18 Thread Jay Sprenkle
On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: I was hoping there was the equivalent of Sybase's BCP program. I was also hoping something programmatic was available, i.e., not something from the command shell. Maybe a little background would help. I'm planning on using the perl p

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-18 Thread Tom Briggs
conversion, nor do I > want to shell out of the code to invoke this. > > jim > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, December 18, 2006 9:12 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Is there a

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-18 Thread Anderson, James H \(IT\)
AIL PROTECTED] Sent: Monday, December 18, 2006 9:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for doing bulk insertion? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > or do I have to creation a gazillion insert statements? > The

Re: [sqlite] Is there a method for doing bulk insertion?

2006-12-18 Thread drh
"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > or do I have to creation a gazillion insert statements? > The sqlite3 command-line shell has a ".import" command which can be used to read CSV data. But the way this works internally is that the command-line shell constructs an INSERT s

[sqlite] Is there a method for doing bulk insertion?

2006-12-18 Thread Anderson, James H \(IT\)
...or do I have to creation a gazillion insert statements? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when rec