>>I need to create a DB
I find the combination of MySQL and OpenOffice to be pretty easy.
Basically, you use MySQL as the database, ODBC to provide a "connector" to
the data source (MySQL), and OpenOffice Calc to populate the database.
What's nice is you can install ODBC connectors on Windows or Linux clients
to access the database running on a Linux or "other" OS. It is somewhat
more complex in that you have three components, but it is quite powerful and
free. Look this over and see if it fits your needs.
http://www.unixodbc.org/doc/OOoMySQL9.pdf
Ken Elliott
=====================
-----Original Message-----
From: slug@nks.net [mailto:slug@nks.net] On Behalf Of SOTL
Sent: Tuesday, February 08, 2005 4:58 PM
To: Linux SLUG
Subject: [SLUG] Data base help
Hi All
I need to create a DB as my current usage of a spreadshead for one has hit
the logical max number of entries of over 10,000 [Ten Thousand] entries.
This is an issue that for most of you would be a triviality but is something
that is above my ability at the current time.
Logically the ideal way to do this would be to buy a book, utilize how tos
et.
and use examples. This of course is a fine procedure if the system one is
using is functional. If the system is not functional then learning what a DB
is suppose to do and learning that the installation is not functioning
correctly can be a daunting task. My last experience with attempting to make
a DB function while not knowing what the DB is suppose to do was to say the
least not a pleasant experience.
Thus I would appreciate it if someone who has some knowledge of DB
installation and writing could demonstrate and help me formulate one at one
of the Linus meetings.
The level of data base I am think of if viewed on a spread sheet should be
about 5 lines wide and 10 or so lines long of the type:
NAME, ADDRESS, CITY, STATE, TITLE
If some one has interest in helping by demonstrating how this is done I
would appreciate their indicating so either on or off list.
Thanks
Frank
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages posted
are those of the author and do not necessarily reflect the official policy
or position of NKS or any of its employees.
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:47:30 EDT