Excel or Access?

R

rerhart

I have server data that is about 200-300 rows/records and includes abou
25 columns/fields. Coworkers have suggested that this data shoul
reside in a database, such as Access, and then import/link to it fro
Excel for reporting purposes.

Does anyone have a recommendation/comment/suggestion on this? I a
comfortable using Excel as my "database" for this data that will no
grow much larger than it already is, and is easier for me to perfor
the reporting in Excel simply on another sheet.

Thanks!
Ric
 
J

jeff

Hi,

Why fix what's not broken? What you should consider
are:

Size: will the database grow? does Excel handle it OK
now if not.

Ease of use: who has to use the data? are they database
savvy? or know Excel? which would be easier for most
normal uses? SQL can be tricky; Access has a decent
GUI/forms if you know how to use set it up and use it.

Performance and security: does Excel do what you want
and do it fast enough? How about security? Can simply
protecting the database with a password (which can be
broken) work OK for your purposes?

Are the suggestors DB-types?? so they're biased toward
Access or other db??

Use what works best for all.

my 2 1/2 cents.
jeff
 
Top