MS Excel as backend/database for the website

[Tigerxxx]

Hello,

If I use MS Excel as the backend/database for a website instead of MS Access
or MS SQL, how stable is it?
Can you please offer any information on the pros and cons of doing so?

Thank you

 

[PvdG42]

Hello,

If I use MS Excel as the backend/database for a website instead of MS
Access
or MS SQL, how stable is it?
Can you please offer any information on the pros and cons of doing so?

Thank you

If you can tell us what kind of data you need to store, and how much, plus
describe how you intend for the data to be accessed, people here can offer
plenty of useful advice. Based of what you've said so far, it's hard to
offer more than a very general response.

My *opinion* is that in most cases data storage and access is best
accomplished by using the tool designed for that capability, a DBMS. Whether
your specific case fits this generalization depends on the details of your
situation.

 

[Ralf-pöschl]

Hello,

If I use MS Excel as the backend/database for a website instead of MS
Access
or MS SQL, how stable is it?
Can you please offer any information on the pros and cons of doing so?

Thank you

 

[Gina Whipp]

Tigerxxx,

Ummm, Excel is not for *backend* to anything let alone a website. Does not
support multiple Users, not meant for data stororage... it is a spreadsheet.
As for Access, I don't believe it *run* over the internet the way you mean
but to see the difference between that and SQL Server...

http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm

With all that out of the way... SQL Server wins hands down AND there is a
free scaled down version available.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm