Export table to Excel Transposed

[choppysuey]

Does anyone know if you can export an access table to an excel spreadsheet in a transposed format (column headings become row headings) directly without having to create an Excel object to make the manipulations? I'm hoping that Access has some function that's like docmd.transferspreadsheet_transposed

 

[danvlas]

You could create a crosstab query in Access...

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[choppysuey]

Thx for the input. I've considered this option. But Access crosstabs only allow for 3 row headings and I need more than that. If Access does not have this built in capability I'll just have to do it the long way.

 

[lespaul]

what do you mean by

But Access crosstabs only allow for 3 row headings

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[choppysuey]

when creating a crosstab using the wizard, you are allowed only 3 row headings. haven't tried creating manually to see if that limit can be exceeded.

 

[jsteph]

You can do more manually. Access' wizards are to be used sparingly.
--Jim