[AccessD] Rotating Excel

John:

Excel has a absolute maximum of 256 columns (1 byte of addressing) so you
cannot directly export any more than that. You are also limited to 65,536
rows but that shouldn't be an issue. While you could export and transpose
256 columns at a time, you are probably better off doing the whole thing in
code: create an excel sheet with 101 columns of text, extract the field
names and write them to the first column, then extract and write the 100
rows to the rest of the columns. I have some code that does something like
this I've used to create cross-tab reports in excel if you'd like.

James Barash

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Tuesday, August 31, 2004 9:10 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Rotating Excel

I need to export data from this big database into Excel.  The objective = is
to get the FIELD NAMES out with data from about 100 records.  I then = need
to rotate excel such that the field names are down the left side and the =
data for each record runs down vertically, the data for any given field runs
across horizontally.  Can anyone tell me how to rotate the spreadsheet =
such that the field names are down the left side?

I assume that the export MUST go out with the field names across the top
row, and the data below that. =20

Can anyone tell me how to get the entire 600+ fields out in a single =
export? When I try to use dts it works but complains (fails) if I try and
export more than about 240 fields.  It LOOKS LIKE perhaps the length of the
= field names in the first row is confusing Excel.  It is telling me I am =
exceeding the 1000 column limit (or some such)

What I really want to do is export all the columns (about 600) with the
field names in the top row, then rotate the whole shootin match.  Any
assistance on any of this is greatly appreciated.


John W. Colby
www.ColbyConsulting.com 


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com