[AccessD] Rotating Excel

Jim Lawrence (AccessD) accessd at shaw.ca
Wed Sep 1 21:54:54 CDT 2004


Hi John:

I believe there is a 1000 column and 65000 row limit to an excel
spreadsheet.

Jim

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