number of field in forms for database in Excel

[adam c]

I was wondering about using Excel as a database. I have a
worksheet with 66 field names (columns), however I am
getting an error that there are "too many fields in the
data form". I read in a textbook that you are allowed 256
fields and 65,536 records. Is it possible for me to
create this database using Excel? What exactly does that
error mean? Am I on the wrong track of thinking?

Thanks

Adam C

 

[Debra Dalgleish]

If you need more than 32 fields, you could try John Walkenbach's
Enhanced Data Form.

http://j-walk.com/ss/dataform/index.htm

 

[Steve Smallman]

Adam,

Excel will permit you to have a worksheet with 256 columns, and 65536 rows.

the Data Form is a tool provided for ease of data entry. the data form is
limited to 32 fields for data entry, basically because thats usually more
than can be read on the form.

If you wish to use a form for data entry, you will need to create a user
defined form, and for 66 fields I would suggest you use the tab control.

Before charging off to do so, have a good think about what you are about to
do. The effort to develop a highly complex form for extensive data entry of
this nature is often more trouble than its worth. Also, you should have a
think about the number of records and the purpose behind storing the info.
You know your needs better than I, but if you have that many fields, and
intend to have a heap of records, maybe you should assess whether or not
Access is a better proposition.

Steve