Excel vs Access

[rigs]

Got a HUGE general question for anyone who wants to send me their opinions. I'm curious what the word is on using excel vs access for database programming. I will be using some math and stats while at the same time requiring a number of people to make changes and update databases without spending hours inputing data from large lists. so therein lies my dilemma...what is better excel or access. any and all opinions are very much appreciated. thanks

Rigs

[malukitojr]

neither one nor the other, y not use both together?

[]Pai_Natal[]

I prefer Excel, for me is the best!!!...

[babis]

What do you want to do?

[Antares]

neither one nor the other, y not use both together?

Judging by what you are describing, that sounds like the most logical and sound route. You can import Excel data into an Access DB with absolutely no problem at all. The only requirement is that the Excel sheet's columns must match the field names of the database you are entering data into.

[b0r3d]

Access was designed for database usage. Ie, keeping records, allowing other people to access your information and make changes with restricted access if you wished. Excel on the other hand, was designed for calculations, such as payroll's etc.

My recommendation would be to use Access for what you need to do.