B Bryan Jun 17, 2004 #1 I have a project that requires 500+ fields (i.e. columns) per record. Any suggestion on working around the 255 limit of Excel??
I have a project that requires 500+ fields (i.e. columns) per record. Any suggestion on working around the 255 limit of Excel??
G Guest Jun 17, 2004 #2 Use the right tool for the job? Access would probably be much better. Secondly, I question that you *really* need 500 fields. You have design issues.
Use the right tool for the job? Access would probably be much better. Secondly, I question that you *really* need 500 fields. You have design issues.
G Gord Dibben Jun 17, 2004 #3 You are stuck with the 256 columns per sheet. Split the data over multiple sheets or use a different product like Quattro Pro which will allow many more columns. Gord Dibben Excel MVP
You are stuck with the 256 columns per sheet. Split the data over multiple sheets or use a different product like Quattro Pro which will allow many more columns. Gord Dibben Excel MVP
C Chip Pearson Jun 18, 2004 #4 Use the right tool for the job? Access would probably be much better. I think Access is limited to 256 columns per table. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message
Use the right tool for the job? Access would probably be much better. I think Access is limited to 256 columns per table. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message
