Constance,
I have worked with Excel for two decades, and I can tell you that it
will easily handle 5000 records on a STABLE machine. But I don't think
the conversion is a good idea because of experiences I have had with
'systems' built on top of Excel Spreadsheets, Access DB, and MS Word.
Can't excel just be setup as the interface to
the database which would allow the excel-centric
users to be happy without stomping on the
structure.
--- Tom Piwowar [EMAIL PROTECTED] wrote:
I think before I let them flatten it I'd consider online solutions
too. Does Google offer a real
Can't excel just be setup as the interface to
the database which would allow the excel-centric
users to be happy without stomping on the
structure.
Excel can import, but read only access may not suffice. They could get
read-write access by simply accessing the database directly via a web
One database has 18 fields, the other 24; the fields are of different
types, and all the fields are fully searchable, both singly and in
combination with other fields. There are multiple layouts...
My co-workers think that an Excel spreadsheet--with four fields--is just
fine to keep track of the
I think before I let them flatten it I'd consider online solutions
too. Does Google offer a real database app now?
Current item of interest is blist.com which provides a happy Flash
interface to PostgreSQL.
* == QUICK
I think it's a given that converting to Excel format will flatten the
heck out of this db. In a way that might require custom coding to
recover from.
But maybe they just want to use Excel for output/conversion to web
format? Nothing wrong with that, as long as the db is intact. Access
should be
, February 06, 2008 8:12 PM
To: COMPUTERGUYS-L@LISTSERV.AOL.COM
Subject: Re: [CGUYS] How stable is Excel?
For nine years, I've been working with two FileMaker Pro databases that
keep track of several thousand documents (including titles,
descriptions, categories, authors, etc.). They've been virtually
For nine years, I've been working with two FileMaker Pro databases that
keep track of several thousand documents (including titles,
descriptions, categories, authors, etc.). They've been virtually
crash-proof and easy to modify. There are nearly 5,000 records (on
separate pages) in these
You can access / modify the DB one record at a time vs. all or nothing
with a spreadsheet.
You can create much more useful / easy queries with the DB than with a
spreadsheet.
Because if they really are that stupid you won't still be working
there to help them out, having fled to a
Not everyone is willing to learn how to drive a stick shift.
Fred Holmes
At 03:44 PM 2/6/2008, Matthew Taylor wrote:
You can access / modify the DB one record at a time vs. all or nothing
with a spreadsheet.
You can create much more useful / easy queries with the DB than with a
spreadsheet.
But everyone who might someday need to drive one in an emergency
should know how.
To further beat the analogy into the ground, if you can't drive a
stick shift, you can't play with the really fun toys.
Back to the subject, how is keeping a database IN a database driving a
stick shift?
Many thanks for the talking points!
And as for #3--
Because if they really are that stupid you won't still be working
there to help them out, having fled to a better, more sane
workplace? ;^)
That one struck a chord! Actually, I AM looking for a better, more sane
workplace, if anyone knows
To: COMPUTERGUYS-L@LISTSERV.AOL.COM
Subject: Re: [CGUYS] How stable is Excel?
Does Filemaker Pro allow for 1) exporting the database to Excel, and 2)
updating the database from Excel? A good one certainly would. Do the
others just read your database, or do they post to it as well?
I would think that Excel
At 04:37 PM 2/6/2008, Matthew Taylor wrote:
Back to the subject, how is keeping a database IN a database driving a
stick shift?
The database interface is more difficult to set up and use, although I guess
the wizards should be pretty good by now. spreadsheet column headings for the
fields
Is this about the database for the Online Buyers Guide that I find on the
PRIMA web site (http://www.primacentral.org/), but which is accessible to
members only? Or is it something that is for internal use only?
Fred Holmes
The Public Risk Management Association wants to use Excel as a
database? Makes you want to say, Hmmm...
g
cb
On Feb 6, 2008, at 3:13 PM, Constance Warner wrote:
And does anyone else have any talking points on why it's a bad idea to
replace a perfectly reliable, crash-proof database with
, February 06, 2008 5:48 PM
To: Computer Guys Announcements and Discussion List
Cc: Constance Warner
Subject: Re: [CGUYS] How stable is Excel?
Is this about the database for the Online Buyers Guide that I find on
the PRIMA web site (http://www.primacentral.org/), but which is
accessible to members only
For nine years, I've been working with two FileMaker Pro databases that
keep track of several thousand documents (including titles,
descriptions, categories, authors, etc.). They've been virtually
crash-proof and easy to modify. There are nearly 5,000 records (on
separate pages) in these
18 matches
Mail list logo