I'm expecting many interesting response to my reply... but here goes..
MS Excel has a row limit of 64,000. If you aren't going over that, then
stick with Excel. If you are going over that, use MS Access. You can
essentially use it like a spreadsheet, except you are limited to many,
many more rows.. up to 4GB of data, if memory serves me correctly. You
can even import your existing spreadsheet into a new table... thus
reducing some work.
Learning MySQL or some other program like that is too much of a hassle
for what it sounds like you need it for. Way over the top.... Keep it
simple. Stick with Access.
SOTL wrote:
>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:48:07 EDT