maximum number of columns

[Louise]

I am trying to import an excel spread sheet into access,
which I have done 100s of times. The spreadsheet is just
200 or so cells that will be my column headings. At first
it seems to have worked but when I try to edit the design
of the table (namely change the text columns from 255
wide to 10 wide) it will let me do a dozen or so and then
gives ma a "Too Many Fields Defined" error message. What
is the Maximum number of columns I can have in Access
2002? Or what else do I need to do?

Thanks

 

[Cheryl Fischer]

The maximum number of fields allowed in an Access table is 255. You can
view additional specifications by going to Access Help and typing
"specifications" in the Answer Wizard.

it seems to have worked but when I try to edit the design
of the table (namely change the text columns from 255
wide to 10 wide) it will let me do a dozen or so and then
gives ma a "Too Many Fields Defined" error message

Changing field widths should not cause a "too many fields" error message -
at least not that I am aware of - but you might want to save your table
design after each change or two.

 

[John Vinson]

I am trying to import an excel spread sheet into access,
which I have done 100s of times. The spreadsheet is just
200 or so cells that will be my column headings. At first
it seems to have worked but when I try to edit the design
of the table (namely change the text columns from 255
wide to 10 wide) it will let me do a dozen or so and then
gives ma a "Too Many Fields Defined" error message. What
is the Maximum number of columns I can have in Access
2002? Or what else do I need to do?

Thanks

You may need to Compact the database. Whenever you change the
properties of a field one of the 255 "slots" gets used up; it can be
recovered by compacting.

I would VERY strongly suggest that if you'll be using this data in
Access rather than Excel, that you quickly move the data from this
wide-flat spreadsheet into properly normalized tables. 50 fields is a
*very* wide table; 200 fields is simply incorrect.

 

[Lefty]

----- Cheryl Fischer wrote: ----

The maximum number of fields allowed in an Access table is 255. You ca
view additional specifications by going to Access Help and typin
"specifications" in the Answer Wizard

it seems to have worked but when I try to edit the desig
of the table (namely change the text columns from 25
wide to 10 wide) it will let me do a dozen or so and the
gives ma a "Too Many Fields Defined" error messag

Changing field widths should not cause a "too many fields" error message
at least not that I am aware of - but you might want to save your tabl
design after each change or two

-
Cheryl Fische
Law/Sys Associate
Houston, T

I am trying to import an excel spread sheet into access
which I have done 100s of times. The spreadsheet is jus
200 or so cells that will be my column headings. At firs
it seems to have worked but when I try to edit the desig
of the table (namely change the text columns from 25
wide to 10 wide) it will let me do a dozen or so and the
gives ma a "Too Many Fields Defined" error message. Wha
is the Maximum number of columns I can have in Acces
2002? Or what else do I need to do

I Have the same problem. I originaly put in 10 wide columns and when I tried to change to 15 I got the same message.

 

[Tim Ferguson]

Changing field widths should not cause a "too many fields" error
message - at least not that I am aware of - but you might want to
save your table design after each change or two.

It will because the new width is added as a new column before the old one
is deleted (it has to be, IYSWIM). It probably needs another new column to
copy itself back over the old name, but I don't know that for sure.

Compacting before will remove traces of old deleted columns, so unless the
OP is starting from 254 fields then all should be well. And if there are
254 fields, then the problem is not about changing field size...

B Wishes


Tim F