[AccessD] Rotating Excel

I may end up doing a little program.  I was hoping for something built in.
Let me look at the transpose thingie.

Thanks,

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Conklin
(Developer at UltraDNT)
Sent: Wednesday, September 01, 2004 11:37 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Rotating Excel


Excel has a Transpose command, which would do what you are asking once in
the worksheet 
... BUT ... It also has a 255 column limit.

How about an ADO recordset ... Loop the fields, write the names to table?

hth
Steve



-----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

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