software

Excel 2003: I have a spreadsheet of 275 rows and columns to FQ.
Column A is all headings.
I want to transpose the entire spreadsheet, so I can then import it into
Access - that is with column headings as columns.
When I copy, go to another worksheet, right click in A1, and select Paste
Special / Transpose, I get the message that the copied data won't fit.
I have done this before successfully, but now - no joy.
I even made sure the row heights were the same!
Any ideas?
Thanks!Since Excel has only 256 columns, you won't be able to transpose 275 rows.

You can transpose half into one worksheet, half into another, then combine
the tow in Access.

quot;Ron Carrquot; wrote:

gt; Excel 2003: I have a spreadsheet of 275 rows and columns to FQ.
gt; Column A is all headings.
gt; I want to transpose the entire spreadsheet, so I can then import it into
gt; Access - that is with column headings as columns.
gt; When I copy, go to another worksheet, right click in A1, and select Paste
gt; Special / Transpose, I get the message that the copied data won't fit.
gt; I have done this before successfully, but now - no joy.
gt; I even made sure the row heights were the same!
gt; Any ideas?
gt; Thanks!
gt;

Of course.
I have my dumb hat on.
Thank you.

quot;Duke Careyquot; wrote:

gt; Since Excel has only 256 columns, you won't be able to transpose 275 rows.
gt;
gt; You can transpose half into one worksheet, half into another, then combine
gt; the tow in Access.
gt;
gt; quot;Ron Carrquot; wrote:
gt;
gt; gt; Excel 2003: I have a spreadsheet of 275 rows and columns to FQ.
gt; gt; Column A is all headings.
gt; gt; I want to transpose the entire spreadsheet, so I can then import it into
gt; gt; Access - that is with column headings as columns.
gt; gt; When I copy, go to another worksheet, right click in A1, and select Paste
gt; gt; Special / Transpose, I get the message that the copied data won't fit.
gt; gt; I have done this before successfully, but now - no joy.
gt; gt; I even made sure the row heights were the same!
gt; gt; Any ideas?
gt; gt; Thanks!
gt; gt;