MS Excel as backend/database for the website

  • Thread starter Thread starter Tigerxxx
  • Start date Start date
T

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
 
Tigerxxx said:
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
Click to expand...

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.
 
Tigerxxx said:
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
Click to expand...
 
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
 
Back
Top