On 8/08/2009 2:02 AM, Simon Slavin wrote:
> On 7 Aug 2009, at 4:21am, aerende wrote:
>
>>sqlite> .import myfile.csv mydatabasetable
>>sqlite> .output mydatabasetable.sql
>
> When you look at the .sql file in a text editor, does it make sense ?
> Does it look like legal SQL ? Does it
On 7 Aug 2009, at 4:21am, aerende wrote:
>sqlite> .import myfile.csv mydatabasetable
>sqlite> .output mydatabasetable.sql
When you look at the .sql file in a text editor, does it make sense ?
Does it look like legal SQL ? Does it have all the INSERT commands in ?
I would probably
> This is why I generally advocate TAB delimited files over CSV
How does .mode tabs cope with quoted strings with tabs or newlines in them?
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
>
John Machin wrote:
>
>>On 7/08/2009 1:21 PM, aerende wrote:
>>> I'm trying to take a CSV file and create a sqlite3 database for the
>>> iPhone.
>>> The CSV file has 33K entries and is 2 MB. The problem I am having is
>>> that
>>> only about 1/10 of the database file gets written into the
Have you tried my SQLiteManager app?
http://www.sqlabs.com/sqlitemanager.php
It can easily convert/import your CSV file into an sqlite3 database.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 7, 2009, at 4:57 PM, Adam DeVita wrote:
> This is why I
This is why I generally advocate TAB delimited files over CSV
Restaurant , Menu Item, Price
Tom, Dick "The MAN", and Harry's Bar & Grill , Specials /new stuff! Mikey's
Burger "Delishiousness ' , $5
If you only have to upload your data once, you should be able to use a
spreadsheet program to
> I'm trying to take a CSV file and create a sqlite3 database for the
> iPhone.
> The CSV file has 33K entries and is 2 MB. The problem I am having is that
> only about 1/10 of the database file gets written into the sqlite3
> database.
The .import csv method is imperfect; if you have quoted
On 7/08/2009 1:21 PM, aerende wrote:
> I'm trying to take a CSV file and create a sqlite3 database for the iPhone.
> The CSV file has 33K entries and is 2 MB. The problem I am having is that
> only about 1/10 of the database file gets written into the sqlite3 database.
>
> I first translated
I'm trying to take a CSV file and create a sqlite3 database for the iPhone.
The CSV file has 33K entries and is 2 MB. The problem I am having is that
only about 1/10 of the database file gets written into the sqlite3 database.
I first translated the CSV file into SQL commands using the
9 matches
Mail list logo