Mattew,
> Obviously I am not as well versed in sqlite as you are. I hate to
> hate myself, but am still continuing with reading somewhat ancient
> files into a somewhat cohorrent database.
>
>Thanking you for your time and trouble,
>
> Matthew
>
>p.s. shame about the parsing of comma delimited files though. Goodnight.
FYI I routinely have to gather a number of data sources into SQLite
DBs. I've found SQLite Expert very useful for that.
Here's a sample nonsensical input:
id,sequence,desc,supplier,reference,flavour,weight
132,0,"text",,"",,4
28,0,"more text, doesn't matter","Dell",87,111
5403,1,"","secondary text",,,
and here's the DDL that Expert made out of it:
CREATE TABLE [tst] (
[id] INTEGER,
[sequence] CHAR(1),
[desc] CHAR(25),
[supplier] CHAR(14),
[reference] INTEGER,
[flavour] INTEGER,
[weight] INTEGER);
now the actual table data:
RecNo id sequence desc supplier reference
flavour weight
----- ---- -------- ------------------------- -------------- ---------
------- ------
1 132
0 text (null) 0 (null) 4
2 28 0 more text, doesn't matter
Dell 87 111 0
3 5403 1 secondary
text (null) (null) (null)
Note how Expert handles successive commas as 'no value supplied', hence
NULL in SQL parlance.
--
<mailto:[email protected]>[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
