ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is excel the best database program ? (https://www.excelbanter.com/excel-discussion-misc-queries/197326-excel-best-database-program.html)

Mike[_12_]

Is excel the best database program ?
 
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[_2_]

Is excel the best database program ?
 
On Sat, 2 Aug 2008 00:59:31 -0500, "Mike" wrote:

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

Is excel the best database program ?
 
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)

"Mike" wrote in message
...
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




Wigi

Is excel the best database program ?
 
Lars-Ã…ke, your lionk did not come trough I guess.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Lars-Ã…ke Aspelin" wrote:

On Sat, 2 Aug 2008 00:59:31 -0500, "Mike" wrote:

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



Lars-Åke Aspelin[_2_]

Is excel the best database program ?
 
On Sat, 2 Aug 2008 02:26:01 -0700, Wigi
wrote:

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/ac...101951033.aspx

Lars-Åke


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com