Number of columns

[Craig]

Does a later version of MS Access and MS Excel than 2000
allow for a greater number of columns than 255 and 256
respectively?

 

[Guest]

-----Original Message-----
Does a later version of MS Access and MS Excel than 2000
allow for a greater number of columns than 255 and 256
respectively?
.

MS Office XP is the next version (2002) and it stll has
the same column limits

 

[Douglas J. Steele]

MS Office XP is the next version (2002) and it stll has
the same column limits

I haven't heard that Office 2003 changes this either. While I can understand
(barely) the desire for more than 256 columns in an Excel spreadsheet, I
can't imagine a need for more than 255 columns in a single table in Access.
With proper database normalization, I'd be shocked if you can show me the
need for more than, say, 40 columns in a single table.