You can multi filter on a spreadsheet.
also, unless you are talking thousands, a spreadsheet is really simple. As for exporting data, csv is very common, in fact for some financial purposes we regularly transfer DB/2 data into csv for use in spreadsheets.

I used to work for a CRM company, and the amount of times we recived data as a csv file was considerable.

If you look at the type of Business Heather seems to have (Nice sites by the way), even a thousand or so would be handled fairly competently.

(I know for a fact that News International in wapping used to handle all their paper ordering on one spreadsheet....scary if you think about it.)


On 3 Jul 2005, at 13:55, Richard McKay wrote:

On 3/7/05 12:02, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:


as much as i hate to say it as a programmer - but if you are talking
about a few hundred you may as well use a spreadsheet..
On 3 Jul 2005, at 11:58, Richard McKay wrote:


My knowledge of spreadsheets is very limited but I thought that one
significant feature that would be missing by doing this instead of using a database (relational not flat) is the lack of ability to filter multiple parameters (sort by name, postcode, product, year in a single sweep)...

Can that be done (without the pain of single sorts and narrowing thereafter?

Another reason that I personally thought one wouldn't want to go spreadsheet route is that in the future (and lets face it if there is no growth then...)
a database would / could expand with one if it is set up properly...I
shudder to think about trying to export/import anything that a business
solely relies upon...

There must be a programmer on this list that has done something like this in
MySQL (even without a GUI) that wouldn't cost the world?

Having said that I don't make my money programming and have no *real*
conception of what amount of energy goes into such a commercial project from
start to end...

Richard
--



--
Mac UK is sponsored by <http://lowendmac.com/> and...

123Inkjets.com <http://lowendmac.com/ad/123inkjets.html>

      Support Low End Mac <http://lowendmac.com/lists/support.html>

Mac UK list info:       <http://lowendmac.com/lists/mac-uk.shtml>
  --> AOL users, remove "mailto:";
Send list messages to:  <mailto:[email protected]>
To unsubscribe, email:  <mailto:[EMAIL PROTECTED]>
For digest mode, email: <mailto:[EMAIL PROTECTED]>
Subscription questions: <mailto:[EMAIL PROTECTED]>
Archive: <http://www.mail-archive.com/mac-uk%40mail.maclaunch.com/>

iPod Accessories for Less
at 1-800-iPOD.COM
Fast Delivery, Low Price, Good Deal
www.1800ipod.com



--
Mac UK is sponsored by <http://lowendmac.com/> and...

123Inkjets.com <http://lowendmac.com/ad/123inkjets.html>

     Support Low End Mac <http://lowendmac.com/lists/support.html>

Mac UK list info:       <http://lowendmac.com/lists/mac-uk.shtml>
 --> AOL users, remove "mailto:";
Send list messages to:  <mailto:[email protected]>
To unsubscribe, email:  <mailto:[EMAIL PROTECTED]>
For digest mode, email: <mailto:[EMAIL PROTECTED]>
Subscription questions: <mailto:[EMAIL PROTECTED]>
Archive: <http://www.mail-archive.com/mac-uk%40mail.maclaunch.com/>

iPod Accessories for Less
at 1-800-iPOD.COM
Fast Delivery, Low Price, Good Deal
www.1800ipod.com

Reply via email to