Re: [sqlite] sqlite3.exe .import command

[EMAIL PROTECTED] wrote: I could find no documentation on format expectations of the .import command. I would appreciate help on this particular problem and also a URL for any documentation of the sqlite3.exe program. Jaime, It's open source code, the source code is the documentation. ;-) See

RE: [sqlite] sqlite3.exe .import command

Ouch! I of course meant to write "can't" instead of "can" in the (corrected) sentence below. E.g. if you are importing a list of names, you *can't* just surround the name with quote chars, such as: "John Smith, Jr.",Anytown,USA --

RE: [sqlite] sqlite3.exe .import command

Re: "...The file I am importing is comma delimited text ..." I believe the default separator is the vertical bar (virgule, "|"), but as Igor wrote, you can easily change it with: .separator , I *don't* think you can quote commas which might appear in your text. E.g. if you are importing a l

[sqlite] sqlite3.exe .import command

I've configured SQLite with RonR and mongrel for use as a development environment on an XP system. I'm replacing an exiting applicaiton and need to migrate data into the new database. All seemed well until I tried to use the .import command in sqlite3.exe. I get a message that 13 fields were