MrExcel Publishing
Your One Stop for Excel Tips & Solutions

What's Better to use for a database - Excel or Word??


Posted by connie on January 11, 2002 3:53 PM

I have never used Excel, but I have done databases and mail merge documents in Word. My new boss said someone told him Excel is better for databases. I will be inputting Names, Addresses, Phone No., Fax No., and later, we will add the person's balance due. Which is better??? And if Excel is, how hard it is if I have NEVER done anything in Excel before?? If it's not better, or has any advantages over Word, I would just like to stick with Word. Any comments, or help?? thanx.


Posted by Mark W. on January 11, 2002 3:58 PM

Use Excel if you have no more than 65536 database
entries.

Posted by connie on January 11, 2002 4:14 PM

Thx Mark - one more question about database....

Thanx for the reply. I would only have approximately 800 people to put in the database. Do you mean 65,536 entries of like the people?? or does the 65,536 include one for the name, one for the address, one for the phone#,,etc?? Also, how can I learn how to do this?? After entering all the info... where do I type the main letter document?? In word??? and how would I 'merge' them????? I am so confused. thanx for any help.

Posted by Bill Gates on January 11, 2002 4:41 PM

Access (NT)

Posted by Lev on January 12, 2002 3:06 AM

Re: Thx Mark - one more question about database....

Posted by Mark W. on January 14, 2002 7:00 AM

Re: Thx Mark - one more question about database....

Connie, see the Excel Help Index topics for...

1. Guidelines for creating a list on a worksheet
2. About using a list as a database
3. Enter data in a Microsoft Excel list by using a form
4. Find data in a list