[Novalug] going from spreadsheet to database
bdalzell at qis.net
Fri Mar 26 10:39:02 EDT 2010
I finally found a tool that runs on my Linux tower set up that allows me
to import into SQLite. It is a firefox add on.
I am not trying to do MySQL right now because I seem to have really messed
up the MySQL install on the desktop tower. I cannot get it to accept a new
password, so I cannot connect to the server. I have tried completely
uninstalling it and reinstalling it. After spending a large number of
hours I think all I can do is to reinstall Ubuntu in my / directory which
I do not want to do right now.
So I am taking the pre-existing dog pedigree database which exists
as a series of pipe separated text files and importing it into series
of sqlite tables.
Two of the relationships from a dog to the record number of its mother and
to the record number of its father should be referring to the record
number in the same table - the main dog record table.
Does anyone have the time to suggest to me how to get those fields in the
main table to refer to the same table. Can I do this after importing?
Bonnie Dalzell, MA
mail:5100 Hydes Rd PO Box 60, Hydes,MD,USA 21082-0060|EMAIL:bdalzell at qis.net
Freelance anatomist, vertebrate paleontologist, writer, illustrator, dog
breeder, computer nerd & iconoclast... Borzoi info at www.borzois.com.
HOME www.batw.net ART bdalzellart.batw.net BUSINESS www.boardingatwedge.com
More information about the Novalug