[AccessD] Rotating Excel

Hale, Jim Jim.Hale at FleetPride.com
Thu Sep 2 14:17:16 CDT 2004


One way to do it would be to create a pivot table with the column heading
field on the left. It could be created from within Excel linking to the
Access table or from within Access using code.
Jim Hale

-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com]
Sent: Tuesday, August 31, 2004 8: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