> >True but if you *do* start in Excel the path through Acess to an SQL
>engine is fairly straight
> >forward. *Any* tool will do if it provides the information that *you*
>particularly want. Using
> >"standard" Microsoft products goes a long way to help in portability.
>Erk. Sorry, but using "standard" Microsoft products won't help one jot
I quite dislike all things Microsoft. However there are one or two people
using their products these days.
>Forget it if you want to easily:
>transfer your data to someone using a Mac, eg someone working doing some
Agree. Macs are a problem. There is Office for Mac though. (However see
point above... )
>transfer your data to someone using Unix, eg if you want to dynamically
>publish your data on a website,
Erm no. There are many ways to transfer data from Microsoft to Unix. At a
push commer delimited would do it. Directly via ODBC is not exactly new
>transfer your data to another database system, eg something to allow
>more than one person to edit the data.
Erm no. Export/Import using one of the many ways available.
>transfer your data to someone running an older version of Office,
Erm not really. Only if you want to use wizz-bang additions of the new
versions that are not backwards compatible.
>You can't really do any serious database work in Excel. It doesn't
>really support multiple tables, autonumbering of fields (for say primary
>keys) , enforcement of referential integrity, 'standard' querying of
>data, or ACID updates.
You cannot do database work with a spreadsheet, of course that is correct.
However you can pull data from databases into spreadsheets and import from
them (especially in Access/Excel scenario).
Don't get me wrong, I am not saying Microsoft products are the best in any
way, neither am I saying that the best thing for a database is not a
database system of some sort but saying that Access/Excel is leaving
yourself not able to port to any other platform or solution is not correct.
People need to use what is available to them and their capabilities this may
not be the best solution.