advantage

MERKY · May 16th, 2002, 07:18 PM

Which is better to use when creating a database, Access or Excel? Why?

Yogi Anand · May 16th, 2002, 07:29 PM

Quote:

On 2002-05-16 19:18, MERKY wrote:
Which is better to use when creating a database, Access or Excel? Why?

If your database requirements are not very extensive, I will use Excel because of its tremendous versatility.
If your requirements are particularly data base oriented, seleting records, organizing information, etc, and you do not need the versatility of Excel, Access is prefered.
One can start in Excel, and if one outgrows Excel's database ecapabilities, one can port the data to Access, or have Excel and Access work together.

Regards!

[ This Message was edited by: Yogi Anand on 2002-05-16 19:29 ]

stevebausch · May 16th, 2002, 08:05 PM

I second the use of Excel, for many reasons:

You can select printer programmatically.

There is also a dialog you can call, so the user can select a printer. Don't forget the SaveSetting GetSetting functions to save settings to Registry.

The Excel VBA editor is much nicer.

If you need to format print, just assign a worksheet for that duty.

It's just a much more versatile environment.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 07:18 PM	#1
MERKY New Member Join Date: Apr 2002 Posts: 38	Which is better to use when creating a database, Access or Excel? Why?

May 16th, 2002, 08:05 PM	#3
stevebausch Board Regular Join Date: May 2002 Posts: 809	I second the use of Excel, for many reasons: You can select printer programmatically. There is also a dialog you can call, so the user can select a printer. Don't forget the SaveSetting GetSetting functions to save settings to Registry. The Excel VBA editor is much nicer. If you need to format print, just assign a worksheet for that duty. It's just a much more versatile environment.