[AccessD] Rotating Excel

Steve Conklin (Developer@UltraDNT) Developer at UltraDNT.com
Wed Sep 1 22:36:44 CDT 2004


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




More information about the AccessD mailing list