Is excel the best database program ?

[Mike]

I have MS home office, which includes Excel. Unlike most in this group,
I am not an Excel power user. I understand that Excel is a spreadsheet
program that can also be used as a database program. I use Excel
as a database program, and it works great for me. I noticed that MS
Access (database program) is not included with MS home office.

So here is my question.
What is MS Access used for, if Excel already does database duties ?
Please help me to understand the difference between them.

Thanks Mike

 

[Lars-Åke Aspelin]

I have MS home office, which includes Excel. Unlike most in this group,
I am not an Excel power user. I understand that Excel is a spreadsheet
program that can also be used as a database program. I use Excel
as a database program, and it works great for me. I noticed that MS
Access (database program) is not included with MS home office.

So here is my question.
What is MS Access used for, if Excel already does database duties ?
Please help me to understand the difference between them.

Thanks Mike

Here is some information on the subject of Excel vs Access.

Hope this helps / Lars-Åke

 

[Bob Phillips]

Even if you don't have Access, you can read and write to an Access database
using ADO and Excel. It is quite simple, so you can separate the data and
the code.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Wigi]

Lars-Ã…ke, your lionk did not come trough I guess.

 

[Lars-Åke Aspelin]

Lars-Åke, your lionk did not come trough I guess.

Thanks Wigi,

Here is the link to some info about using Access or Excel:

http://office.microsoft.com/en-us/access/HA102101951033.aspx

Lars-Åke