LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Jezebel
 
Posts: n/a
Default should I learn Excel ?

The fact that you don't understand flat file databases -- presumably you
weren't taught about them because they were already out-of-date -- doesn't
invalidate the concept. You just make yourself look silly making pompous
declarations on a topic that you admit you don't understand.

And you might be wise to look up 'oxymoron' before you embarrass yourself
any further.





"Bob Phillips" wrote in message
...
Hi Rodney,

I think that is my point. Excel is NOT a database, however hard many
people
try and make it (including MS in 12?), and a flat file is a flat file. It
might be able to manage tasks that were originally done by flat files or
even databases, but it still is not one. A database as I was taught has
files/tables whatever, and a some form of structure. So to me, a flat file
database is an oxymoron.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rodney" wrote in message
...
G'day Bob,
Excel is a flat file database, when used as such,
as opposed to a "Relational Database, eg: Access

A flat file database is described by a very simple database model,
where all the information is stored in a plain text file, one database
record per line. Each record is divided into fields using delimiters or
at fixed column positions. The data is "flat", as in a sheet of paper,
as compared to a more complex model such as a relational database.

I use MSWorks for smaller files, but that will only take 32,000 records,
so for larger volume, I have to sneak over to Excel.
The benefits of MSWorks include a learning curve of about 10 minutes
to be up and running, and for small jobs, like organising Local Cricket
database, record collections, and so forth.
HTH





| What is a flat file database? Sounds like a contradiction to me.








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Value Errors with EXCEL XP not showing up in EXCEL 2000 goodguy Links and Linking in Excel 0 July 19th 05 02:38 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"